SELECT PARTDET.PART, PARTHDR.`DESC`, PARTDET.`DATE`, PARTDET.REMAINQTY, PARTDET.UNITPRICE, PARTDET.PURCHASENO FROM PARTHDR, PARTDET WHERE PARTHDR.PART = PARTDET.PART AND (PARTDET.REMAINQTY ＞ 0) AND PARTDET.PART LIKE ('C*') ORDER BY PARTDET.PART, PARTDET.`DATE`
以上未能顯示所有partdet.part 由 C 開始的資料??Why??
Thx a lot