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 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]