Hi all,
I want to get the difference between 2 tables.
table_1:
column_1
A
B
C
D
table_2:
column_2
B
C
What is the sql select syntax to get as result A,D or B,C?
Thanx for your help.
Regards,
Bernd
-
Before
mysql select table1.* from table1
LEFT JOIN table2 ON table1.column_1=table2.column_2
where table2.column_2 is NULL;
try this to select row of table 2 not in table 1, i think.
Hi all,
I want to get the difference between 2 tables.
table_1:
column_1
A
B
C
Hi David,
On Wed, Apr 03, 2002 at 02:10:03PM +0200, David yahoo wrote:
mysql select table1.* from table1
LEFT JOIN table2 ON table1.column_1=table2.column_2
where table2.column_2 is NULL;
try this to select row of table 2 not in table 1, i think.
Yes, it's working.
Bernd,
Wednesday, April 03, 2002, 2:42:33 PM, you wrote:
BM I want to get the difference between 2 tables.
BM table_1:
BM column_1
BM A
BM B
BM C
BM D
BM table_2:
BM column_2
BM B
BM C
BM What is the sql select syntax to get as result A,D or B,C?
Look at JOIN clause: