Hi,

What is syntax for joining 3 tables?

"SELECT * FROM Class INNER JOIN Teacher ON Teacher.TeacherID = Class.TeacherID"

This works fine, but how do I add another table to the equation here?

Thanks

__________________
Arowolo

By quickly "googling" I found these two links:
1. http://p2p.wrox.com/topic.aspx?TOPIC_ID=19369
2. http://www.databasejournal.com/sqlet...6861_1402351_3

If you need any further assistance do write back.

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com