I have a co-worker who has devised this method of querying multiple data tables:
SELECT * FROM Students, Bookings, RotaryClubs, Schools WHERE Students.RotaryID=RotaryClubs.RotaryID and Bookings.StudentID=Students.StudentID and Schools.SchoolID=Bookings.SchoolID
And much to my surprise, it seems to work!
Is there anything wrong with this method? What benefits do INNER JOINs give over this method?