joins on more than 2 tables
hi,
i am a beginner so please bear with me...thanks
i can do a simple join quert on 2 tables eg
"select id, name, address, payroll_number, pay_scale
from personnel join payroll on [personnel].id=[payroll].id"
BUT...
what if i need to get further information from another
table ( ie a 3rd table ) and also join on the id field ?
If this makes sense - could anyone kindly give me a code example
as i cannot find one in any book. The code examples i have
only do joins on 2 tables at a time.
Many thanks for any replies.
Chas. UK
|