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(veryUrgent)


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 char(2);
                Second(Shop,Date,Flower,Color);

first table will contain only unique flowers , and colors, id is
autoincrement.

second table may contain duplicate entries.


i want to select from Second table only those Flowers and Colors  which are
not there in First table.

i tried with : select distinct(First.Flower),First.color from First,Second
where First.color!=Second.color;

but it will select all fileds in first.


As this version of mysql will not support for subqurries...problem.

can anybody reply with answer?

===================================================
kavi
===================================================


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to