select *

[Hiep Nguyen]

hi all,

how do i select all fields in tbl1,tbl2, and only fld1,fld2 in tbl3?
is this possible???

select *,*,tbl3.fld1,tbl3.fld2 from tbl1,tbl2,tbl3;

the reason for this is b/c there are hundred of fields in tbl1 & tbl2 that 
i don't want to type them all.

thanks,
t. hiep



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]