Re: MySQL syntax different from Microsoft SQL syntax...Please HELP

2002-03-18 Thread Paul DuBois
At 18:15 -0500 3/18/02, John Burns wrote: >I've looked throught the MySQL documentation and I can't seem to find the >answer to this problem. I have a query that will work on a Microsoft SQL >server, but I've tried moving it to a MySQL server and it won't work. I >tried modifying it and I can't

Re: MySQL syntax different from Microsoft SQL syntax...Please HELP

2002-03-18 Thread Christopher Thompson
What error message do you get? Have you tried fully spelling out your join condition's table names? Have you tried specifying that you are doing a LEFT join? Have you tried using USING instead of ON? On Monday 18 March 2002 4:15 pm, John Burns wrote: > I've looked throught the MySQL document

MySQL syntax different from Microsoft SQL syntax...Please HELP

2002-03-18 Thread John Burns
I've looked throught the MySQL documentation and I can't seem to find the answer to this problem. I have a query that will work on a Microsoft SQL server, but I've tried moving it to a MySQL server and it won't work. I tried modifying it and I can't get it to work either. The scenario and synta