I'm using MySQL-4.1 alpha because it's support sub-select. But i've tried and the result takes very long time (more then 30 seconds). The query is: SELECT T.*, C.NAME FROM arTAGIH T, arCUSTOMER C, arBILL_LNS WHERE T.BILL_NO NOT IN (SELECT BILL_NO FROM arBILL_LNS) AND T.CUST_CODE=C.CUST_CODE AND T.D_R=arBILL_LNS.D_R AND T.CUST_CODE='ABA' ORDER BY T.TANGGAL" The comparison, using MySQL takes 80 seconds, and using MSDE not more than 5 seconds. Is there something wrong with that query or it's true that MySQL has limited ability for sub-select
Thank's Roji
