On Tue, Apr 1, 2008 at 11:15 AM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:

> how do i select all fields in tbl1,tbl2, and only fld1,fld2 in tbl3?
>
select tbl2.*,
 tbl1.*,
 tbl3.fld1,
 tbl3.fld2
from tbl1,tbl2,tbl3;
Please also consider using explicit JOINs.

-- 
Rob Wultsch
[EMAIL PROTECTED]
wultsch (aim)

Reply via email to