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