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
