...how can union be the same as intersect..iam trying to get the names of comapnies that are in both queries.....for example the first query gives me companies A, B AND C and the second query gives A , B..i want the intersect of these 2 queries....so i get companies A and B...if i did a union i will get A, B and C
On Wed, 3 Nov 2004 09:13:08 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Assuming you have access to MySQL 4.0+ > > select csymbol from tblavgPrice where avg > 1 and avg < 10 > UNION > select csymbol from tblAssets where assets > 100 and assets < 500 > > Unless you say UNION ALL, you won't get duplicate values. > For more details: http://dev.mysql.com/doc/mysql/en/UNION.html > > Just out of curiosity and because this is not the first time the INTERSECT > question has come up. What SQL dialect are 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 Corporation - Spruce Pine > > > Chaitra Yale <[EMAIL PROTECTED]> wrote on 11/03/2004 02:12:42 AM: > > > > > 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 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]