ANSI-89 vs ANSI-92

  • Thread starter Thread starter Leo Karl
  • Start date Start date
L

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
 
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?
Click to expand...

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