>I want to do a join involving 3 tables using a select statement. No relations involved and no UDFs either.
>
>Table A (field1, field2, ...)
>
>Table B (field1, field4, ...
>
>Table C (field2, field5, ...)
>
>I want to join (A LEFT OUTER JOIN B on field1) and Left outer this result C on field 2

well, what you wrote is pretty much what you need

SELECT ... FROM (TableA LEFT JOIN TableB on TableA.Field1=TableB.Field1) LEFT JOIN TableC on TableA.field2=TableC.Field2 ...

Arnon