ANSI-89 vs ANSI-92

[Leo Karl]

Come to find out that this query:

SELECT first.cname, second.cname, first.rating
FROM Customers AS first, Customers AS second
WHERE first.rating = second.rating;

Will work under ANSI-89, but produces a syntax error when run under ANSI-92.

Can anyone tell me how to code it for running under ANSI-92?

Thanks, Leo

 

[John Vinson]

Come to find out that this query:

SELECT first.cname, second.cname, first.rating
FROM Customers AS first, Customers AS second
WHERE first.rating = second.rating;

Will work under ANSI-89, but produces a syntax error when run under ANSI-92.

Can anyone tell me how to code it for running under ANSI-92?

SELECT first.cname, second.cname, first.rating
FROM Customers AS first INNER JOIN Customers AS second
ON first.rating = second.rating;

 

[Van T. Dinh]

Check my reply in your previous thread.