Re: HELP: postgreSQL query -> MySQL query

2002-02-26 Thread wally liau
sorry guys, it isn't intended to post a message repeatedly. Yahoo keeps telling me that the message was not delievered due to some sort of size problem. Anyway, I'm still seeking a solution to my problem and would appreciate any of your help. Thanks --- Benjamin Pflugmann <[EMAIL PROTECTED]>

Re: HELP: postgreSQL query -> MySQL query

2002-02-26 Thread Benjamin Pflugmann
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. O

HELP: postgreSQL query -> MySQL query

2002-02-25 Thread wally liau
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 p

HELP: postgreSQL query -> MySQL query

2002-02-25 Thread wally liau
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 p

HELP: postgreSQL query -> MySQL Query

2002-02-25 Thread wally liau
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 p