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)