On Fri, 17 Apr 2009, flakpit wrote: > Currently, I return any needed data like this. > > select * from pubs,notes,publishers where pub_title like '%salem%' > and pubs.note_id=notes.note_id > and pubs.publisher_id=publishers.publisher_id > > And it works except for all fields in the matching tables being returned.
'*' means 'return all fields'. This has nothing to do with the joins, even if you are selecting from a single table '*' means return all fields: select * from tableA returns all columns from tableA. If you only want some fields, just name them in the SELECT: select pubs.note_id, pubs.publisher_id from ... Chris > Is there any way using joins (been playing but can't get them working) so > that a statement like > > pubs.note_id=notes.note_id > > Would return only the contents of the notes.note_note field and not all the > fields in the notes table? > -- > View this message in context: > http://www.nabble.com/Slim-down-join-results-%28all-fields-returned%29-tp23098746p23098746.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
