pls delete my post

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

Re: INTERSECT in mysql

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 Corporation - Spruce Pine Chaitra Yale [EMAIL PROTECTED] wrote on 11/03/2004 02:12:42 AM: hi i have

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