[RESOLVED] query select from 3 tables at once

[visualAd]

I don't mind that format, it's a bit more intuitive to me, and I've not yet used a DBMS where it didn't work. But I realize those are all personal reasons, and I know the JOIN syntax has its advantages. Just brought it up in case it was conceptually clearer.

Some DBMS' will make optimization decisions based on whether or not you use a join or a where clause, so watch out.

Also I cannot think of any good reason why you would want to have a join with no condition. Joining 3 tables each with 20 rows and no join condition would result in a record set containing 8000 rows.