SELECT cust.name，rcVBles.balance，……other columns SELECT cust.name，rcVBles.balance，……other columns FROM cust，rcvbles WHERE cust.customer_id = rcvlbes.customer_id AND rcvblls.balance>0 AND cust.postcode>"98000" ORDER BY cust.name
SELECT cust.name，rcvbles.balance，……other columns SELECT cust.name，rcvbles.balance，……other columns FROM cust，rcvbles WHERE cust.customer_id = rcvlbes.customer_id AND rcvblls.balance>0 ORDER BY cust.name INTO TEMP cust_with_balance
然后以下面的方式在臨時表中查詢:
復制代碼 代碼如下:
SELECT * FROM cust_with_balance WHERE postcode>"98000"
