Hi I am wondering how to take referenced data from another table. Sorry I'm not sure how to say what is so I'll give an example.
Person 1 has in the table
person1id
firstname
lastname
In another table is the job and it has
person (Here is gives the persons id)
Job_title
department
How can I query the database so that I can echo the job title, department and first and last name?
Thanks..sorry if its such a low question i've just not built this before myself. Usually when I create something each database has its own content.
Thanks for any assistance. php/mysql
Michael
