On 5/20/2011 8:36 PM, Yves Plasse wrote: > I have two tables (msglog and msgtbl) I want do join together. On both table, > I have the following common fields: > > iDeviceId Integer > iGroupId Integer > iCodeId Integer > tMsg Text > > When I enter the following command, the table joins together but there is a > lot of fields in msgtbl that I dont need: > > select * from msglog > left outer join msgtbl > on msglog.iDeviceId == msgtbl.iDeviceId > and msglog.iGroupId == msgtbl.iGroupId > and msglog.iCodeId == msgtbl.iCodeId > > On the second table, I just need the field tMsg
select msglog.*, msgtbl.tMsg from ...; -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
