: 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
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
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 tab