>SELECT pubs.* from pubs, notes, publishers WHERE ... Thanks, but it didn't work the way I expected it to:)
Now I have my query laid out a lot better and can 'slim' it down from here SELECT * FROM pubs INNER JOIN notes ON pubs.note_id=notes.note_id ; notes. INNER JOIN publishers ON pubs.publisher_id=publishers.publisher_id WHERE pub_title LIKE '%salem%' How do I return only the matching notes.note_notes field in that join and no the rest of the fields in notes? How do I return only the matching publishers.publisher_name field in that join and not the rest of the fields in publishers? Probably still explaining myself very badly here. Oh well. -- View this message in context: http://www.nabble.com/Slim-down-join-results-%28all-fields-returned%29-tp23098746p23107065.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
