Re: [sqlite] how do I use more than one column as a "combined key"?

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

Re: [sqlite] how do I use more than one column as a "combined key"?

yaconsult wrote: >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

Re: [sqlite] how do I use more than one column as a "combined key"?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 yaconsult wrote: > 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

[sqlite] how do I use more than one column as a "combined key"?

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