¹øÈ£ |
Á¦¸ñ |
µî·ÏÀÚ |
ºÐ´ã±Ý¾× |
¼öÀÍ±Ý¾× |
ÆÇ¸Å±Ý¾× |
ÆǸÅÀÏ |
SELECT TB.SUBJECT,TB.PRICE,TB.REGDATE,K.PDS_CATE,K.UID,K.UNAME FROM MP_TEMPBUY AS TB,MP_KNOWLEDGE AS K,MP_ORDER AS OD WHERE TB.FLAG = 'K' AND left(TB.REGDATE,7) = '2024-07' AND K.KNO = TB.P_NO AND TB.O_NO = OD.ORDER_NO AND OD.R_RESULT NOT IN ('C','R') ORDER BY TB.NO DESC
1 |
ENIDINE |
ÃÖº´±Ç [zergnet] |
1,500 ¿ø |
1,500 ¿ø |
3000 ¿ø |
2024-07-11 |
|