> 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. > > 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?
Is this what you are looking for: SELECT pubs.* from pubs, notes, publishers WHERE ... _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
