0$10 how to do a join in Interactive SQL on DF1?

[bub]

Help, help, why i can't do something like this in Interactive SQL on a 
DF1 session?

Select * from A

left join B ON A.b_id = B.id

i tried 'join' 'inner join' etc, i keep on getting 'Badly formed SQL 
statement', i get that message way too much in all kinds of standard SQL 
statements... @##$@

I am working my way to understanding Studio by stepping through existing 
app code and now that i am on this subject, maybe i don't have to go so 
much into interactive SQL if i understood a bit more about this whole 
file, table, schema stuff.  I start to get the basics but where am i 
looking to find the table-relations, are these normally defined in the 
table classes?

Thanks as always

Bruno Huyssen