I don't undertand what is your question? a) You know to do it in SQL but you don't in SQLite or b) You dont know how to do it in any SQL
yaconsult escribió: > SQL newbie here. Sqlite has been a fantastic tool for analyzing, comparing > and correcting lots of account information. But I've hit a roadblock > because I don't know how to treat multiple columns as a kind of combined > key. > > I need to know how to relate two tables > on multiple columns. > > It's been easy when I only had to relate > using a single column. > > The tables are pretty big - 20,000+ entries. > > User Accounts > name > uid > server > login > . > . > . > > Calendar Accounts > server > login > firstname > lastname > . > . > . > > > What I need to be able to do is to check > that the server and login information > in the first table matches one and only > one of the accounts in the second table. > > What I'm having trouble figuring out is > how to use the server and login as > a combined key. > > When I have a single unique value that > I can relate, like a DS ID, I know how > to do that. > > How can I query to find out which user > accounts don't match up with one and > only one calendar accounts? And which > calendar accounts are not associated > with a single user account? > > Thanks for any help you can provide. > Sqlite is the perfect tool for this kind of stuff! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
