Hi all,

A proposed solution I found online regarding our problem with integrating
MySQL into our system is:

Given the following query

Select * from A, B INNER JOIN tableC AS C ON A.field1 = C.field2

we get an error claiming that it cannot find 'field1' because the JOIN
operation has precedence over ',' (comma). A work around seems to be
changing the ',' into 'JOIN" keyword.

Now I need to find a way to change a couple queries to make sure this
approach will give the correct results and if it works, then we can go
ahead and change them all.

Can someone please advise me on how I can go about finding queries
of the above nature?

Thank you in advance,


-- 
Regards,

Rokham Sadeghnezhadfard
University of Toronto
Software Engineering Specialist

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"SAIL-Dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/SAIL-Dev?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to