|
|
Posted by Paul E Collins on 11/17/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.
Navigation:
[Reply to this message]
|