On Tue, 1 Apr 2008, Rob Wultsch <[EMAIL PROTECTED]> wrote:
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;
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, [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
