-----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 server and login as > a combined key.
The general process of doing this is called normalization. Wikipedia has an article to start you off: http://en.wikipedia.org/wiki/Database_normalization Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkoJ5l8ACgkQmOOfHg372QRBHQCfTSweDCxgImb44SKG3uGnqi3e CXYAoJc4TDmmdPyRgafrlrteXgLmGrKw =Wjx8 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users