From: Tim McDaniel (tmcdpanix.com)
Date: Tue Apr 01 2008 - 13:54:19 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Tue, 1 Apr 2008, Rob Wultsch <wultschgmail.com> wrote:
> On Tue, Apr 1, 2008 at 11:15 AM, Hiep Nguyen <hiepee.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, tmcdpanix.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]