Hi Sachin I have tried LEFT SEMI JOIN, but the results are the same to a JOIN operation. Richard
At 2012-03-12 12:03:39,[email protected] wrote: Hi richard, You can use left semi join. SELECT a.key. FROM a LEFT SEMI JOIN b on (a.key = b.key) Thanks, Sachin Sent from BlackBerry® on Airtel From: Richard <[email protected]> Date: Mon, 12 Mar 2012 11:52:11 +0800 (CST) To: <[email protected]> ReplyTo: [email protected] Subject: how to join like a "In A but not in B" operation? hi, how can I join two tables A and B so that the result is "In A but not in B"? let's take an example, say, the column to identify record is id. e.g. select A.* from A join B on (A.id = B.id) thanks. Richard
