-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Fri, 27 Jun 2003 02:49:21 -0400, [EMAIL PROTECTED] wrote:
>I don't understand how to morph the following with your specification: >SELECT firstName, lastName, deptPOS, workPH, homePH, location, model, >make, propID, addressIP, OS FROM people, make, models, machines >WHERE people.peopleID = machines.peopleID AND make.makeID = >models.makeID AND models.modelID = machines.modelID > The statement above + "AND people.peopleID = some_specific_ID" - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE+/MyZsxxMki0foKoRAgDvAKDvpA1u0GLEBavvpX21+HpTZMG7AQCg+rdl tSqjktZb/ooiLlYdjUth94g= =s8Ek -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
