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!
--
View this message in context:
http://www.nabble.com/how-do-I-use-more-than-one-column-as-a-%22combined-key%22--tp23510319p23510319.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
