LEFT Join with multiple tables in SQL query - dBforums

I need an SQL query to retrive columns from 3 related tables a,b,c. ... select f.foo , b.bar , q.qux from footable as f left outer join bartable as b on f.id ... For example, let's say that tables A, B, and C each have 1,000 records each.

www.dbforums.com