|
Posted by Syl on 12/31/06 05:11
Hello! Can someone verify this for me please.
Should these 2 statments return the same result ? The 2nd one is the
original, the first one is my re-write. Thanks :
SELECT orders_status, paypalipn_txn . *
FROM orders
INNER JOIN paypalipn_txn ON item_number = orders_id
WHERE customers_id = 4417
ORDER BY date_purchased DESC LIMIT 1
and :
SELECT o.orders_status,p.*
FROM orders o
LEFT JOIN paypalipn_txn p on p.item_number = o.orders_id
AND o.customers_id = 4417 order by o.date_purchased desc limit 1
Navigation:
[Reply to this message]
|