Hi. Could you please stop to post your message repeatedly with only some minutes in between?
I never used INTERSECT, so I don't know... does it do anything a normal join doesn't? Like SELECT * FROM table1 t1, table2 t2, table3 t3 WHERE t1.id=t2.id AND t2.id=t3.id Bye, Benjamin. On Mon, Feb 25, 2002 at 06:32:55PM -0800, [EMAIL PROTECTED] wrote: > Hi there, > > I have a postgreSQL query like > > (SELECT ... FROM... WHERE...) INTERSECT > (SELECT ... FROM... WHERE...) INTERSECT > (SELECT ... FROM... WHERE...) ........ > > and I'd like to have an equivalent MySQL query. Your > help would be greatly appreciated. > > The reason is that we were running Java programs from > Linux machines that has postgreSQL and now switched to > Unix that has only MySQL (don't ask me why not get > postgreSQL installed). > > Please copy to my email address. > > Thanks a lot. [...] -- [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php