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:
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 worki
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
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 post
