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? -- 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
