[Eclug] OT: SQL question

On 2006.10.08 19:14, David Krings wrote:
> I didn't know that. I always thought that SELECT table1, table2 ....  
> simply indicates that I want to access fields within table1 and  
> table2, but doesn't relate the tables in any way. Maybe I  
> misunderstood you, but how is the db engine supposed to know on what  
> to join when I don't specify a field?

It actually does a full outer join - and you get the combination of  
every row in one table with each row from the other table.  Most of the  
time, you simply include some condition in the where clause that limits  
to the combination you want - such as some identifier being the same in  
the rows from both tables.