Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Tim McDaniel (tmcdpanix.com)
Date: Tue Apr 01 2008 - 13:54:19 CDT
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.*,
> 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
> 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