[SQL] joins again

[CB]

Hi,

Can someone tell me which (if any) joins are supported with 7?  It
appears the answer is 'none' but I want to make sure.  Since I think the
answer is 'none' can someone tell me how you emulate inner and outer
joins using the where clause (I need an example)?  Thanks!

Craig