pls delete my post

http://lists.mysql.com/mysql/175156 it shows when someone does a search on my name. Thanks -- Regards Chaitra Yale

INTERSECT in mysql

hi i have a problem mysql doesnt seem to support the intersect can somebody help how i can write the followoing code in mysql select csymbol from tblavgPrice where avg > 1 and avg < 10 intersect select csymbol from tblAssets where assets > 100 and assets < 500 thanks -- MySQL General Mailing

Re: INTERSECT in mysql

you coming from? > > IF you are using a MySQL server that is pre-4.0+, you will have to recode > that query using any of several variations that use a temporary table. Let > me know if you need that work-around. > > Shawn Green > Database Administrator > Unimin Corporatio