Posted by Paul E Collins on 10/22/93 11:39

"alvonsius" <alvonsius.albert@gmail.com> wrote:

> SELECT
> A.name AS name_A,
> B.name AS name_B
> FROM A, B WHERE A.id = B.id

Yep, thanks. The aliases make the query that little bit longer, but
it's not a big problem.

> PS: why don't you use LEFT JOIN ??

Well, in my real query it's an inner join. This was just a rather
meaningless example. If you're asking why I use the comma notation, I
just find it a bit more readable than "JOIN... JOIN... JOIN" when
several tables are involved.

P.

[Back to original message]