G
Guest
Можно ли сделать так, что бы запрос вроде
SELECT first.cname, second.cname, first.rating
FROM Customers first, Customers second
WHERE first.rating = second.rating;
не "переделывался" в
SELECT [first].CNAME, [second].CNAME AS Expr1, [first].RATING
FROM Customers [first] INNER JOIN
Customers [second] ON [first].RATING = [second].RATING
?
SELECT first.cname, second.cname, first.rating
FROM Customers first, Customers second
WHERE first.rating = second.rating;
не "переделывался" в
SELECT [first].CNAME, [second].CNAME AS Expr1, [first].RATING
FROM Customers [first] INNER JOIN
Customers [second] ON [first].RATING = [second].RATING
?