Pichan,
Thursday, March 14, 2002, 6:19:23 AM, you wrote:
PM> I have 2 tables, let says, table A and table B. Each table record person
PM> name.
PM> select B.name from B, A where B.name = A.name
PM> Query above should return the name which recorded in both tables (duplicate
PM> name)
PM> In r
Try:
SELECT B.name FROM B LEFT JOIN A ON A.name = B.name WHERE A.name is null;
-Original Message-
From: Pichan M. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 14 March 2002 12:19 PM
To: [EMAIL PROTECTED]
Subject: Retrive distinct data from two tables
I have 2 tables, let says, table A
I have 2 tables, let says, table A and table B. Each table record person
name.
select B.name from B, A where B.name = A.name
Query above should return the name which recorded in both tables (duplicate
name)
In reverse, how can I retrive the name which recorded in Table B and not
present in T
