SQL newbie here. I have data in a couple of tables that I need to relate. But I don't know how to relate on more than one column. I'll not go into detail about why the data is formed the way it is - it comes from other programs.
For example, let's say there are a couple of tables: server login name last_login email ... and we have a second table that contains columns for server and login: server login How can I, for example, select rows of the first table where their server and login, combined, are NOT in the second table. It's sorta like a composite key. Do I do it with a couple of joins? Could I see an example? If it were only a single column I could use a "not in" subselect, but I'm not sure how to do it when it involves more than one column. Thanks for any help! -- View this message in context: http://www.nabble.com/How-do-I-do-this-join-on-multiple-columns--tp22301000p22301000.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
