sac.khurana@... 2012-03-12, 04:05
Richard 2012-03-12, 03:52
sac.khurana@... 2012-03-12, 04:03
I have tried LEFT SEMI JOIN, but the results are the same to a JOIN operation.
At 2012-03-12 12:03:39,[EMAIL PROTECTED] wrote:
You can use left semi join.
FROM a LEFT SEMI JOIN b on (a.key = b.key)
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?
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.
select A.* from A join B on (A.id = B.id)
Raghunath, Ranjith 2012-03-12, 05:43
sac.khurana@... 2012-03-12, 12:44
Evan Pollan 2012-03-12, 04:03
Richard 2012-03-12, 07:18