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
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
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