On Tue, 1 Apr 2008, Rob Wultsch <wultsch@gmail.com> wrote:
> On Tue, Apr 1, 2008 at 11:15 AM, Hiep Nguyen <hiep@ee.ucr.edu> 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;

Hiep, will you be supplying a WHERE clause to keep from getting all
possible combinations of rows from tbl1, tbl2, and tbl3? (Or am I
misunderstanding something?)

> Please also consider using explicit JOINs.

Another way to do the same thing with different syntax, right?

--
Tim McDaniel, tmcd@panix.com