Hi, Which of the two query options is better?
SELECT a.item_id, a.create_dt FROM a JOIN b ON (a.item_id = b.item_id) WHERE a.item_id = 'I001' AND a.category_name = 'C001'; - or - SELECT a.item_id, a.create_dt FROM a JOIN b ON (a.item_id = b.item_id AND a.item_id = 'I001') WHERE a.category_name = 'C001'; Thanks Naga