What part of SAIL is making these queries? If this is about the portal, the Pas-Portal-Dev list may be a better place to ask.
On Oct 10, 12:41 am, "Rokham Sadeghnezhadfard" <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
