SELECT s.* FROM Second s LEFT JOIN First f USING (Flower,Color) WHERE
f.Flower IS NULL;
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: N. Kavithashree
Sent: Tuesday, January 04, 2005 11:17 PM
To: mysql@lists.mysql.com
Subject: distinctSelection
select * from secondtable left outer join second.flower=first.flower
and second.color=first.color where first.flower is NULL
N. Kavithashree wrote:
hello,
i m using mysql 4.0.18-standard version
it is not accepting subqurries.
problem is:
i have 2 tables: First(id,Flower,Color); => color is ch
