* Chris Blake > I have created two tables > Clients and Jobs > > One Client has many jobs.how do I create a relation between the two > tables ?
Simply by including a column in the jobs table 'pointing' to the client table. Say, for instance, that the Client table have a unique primary key called Client_id, you would add a Client_id column to the jobs table, giving each job 'a pointer' to the corresponding Client. -- Roger sql --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
