Q: MS SQL queries -> ANSI SQL
I believe you can make both queries on Access. Or don't? What's the
advantage of using INNER JOIN instead of WHERE?
Quote:
>Hi,
>Does anyone know of an API call (possibly to odbc.dll) that
>would allow one to send as a string, Microsoft SQL (from MS
>Access) and return the ANSI equivelant. The example below
>shows an example of what I mean:
>Microsoft SQL:
>SELECT DISTINCTROW Paragraph.Paragraph_Number,
>[Confirmation_Type].Confirmation_Type_Name,
>Paragraph.Paragraph_Text
>FROM ([Confirmation_Type] INNER JOIN
>[Confirmation_Paragraph_INT] ON
>[Confirmation_Type].Confirmation_Type_Code =
>[Confirmation_Paragraph_INT].Confirmation_Type_Code) INNER JOIN
>Paragraph ON [Confirmation_Paragraph_INT].Paragraph_Code =
>Paragraph.Paragraph_Code;
>ANSI SQL:
>SELECT DISTINCT Paragraph.Paragraph_Number,
>Confirmation_Type.Confirmation_Type_Name,
>Paragraph.Paragraph_Text
>FROM Confirmation_Paragraph_INT, Confirmation_Type, Paragraph
>WHERE
>((Confirmation_Paragraph_INT.Paragraph_Code=Paragraph.Paragraph
>_Code) AND (Confirmation_Paragraph_INT.Confirmation_Type_Code=
>Confirmation_Type.Confirmation_Type_Code));
>Basically I'd love to know if there is a function along the
>lines of (perhaps someone has written a dll to do this?):
>cSQLANSI=SQLtoANSI(MsQuery)
>Hope someone can help.
>Jimi
>--
> \|/
> (*.*)
>*---------------------------------------oOO--(=)--OOo-----*
>| James B Tollan |
>| London, United Kingdom |
>| |
>| O tongue, thou art a treasure without end. |
>| |
>| And, O tongue, thou art also |
>| a disease without remedy. |
>| == Jelal'uddin Rumi == |
>*---------------------------------------------------------*
