slamhound
asked on
Inner Join or Not Inner Join...
I have a co-worker who has devised this method of querying multiple data tables:
SELECT * FROM Students, Bookings, RotaryClubs, Schools WHERE Students.RotaryID=RotaryCl ubs.Rotary ID and Bookings.StudentID=Student s.StudentI D 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?
SELECT * FROM Students, Bookings, RotaryClubs, Schools WHERE Students.RotaryID=RotaryCl
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> The only thing you can benefit from inner joins is the better readability of the code.
Matter of opinion. Much prefer the abbreviated syntax as easier to format (and less typing).
Matter of opinion. Much prefer the abbreviated syntax as easier to format (and less typing).
The only thing you can benefit from inner joins is the better readability of the code.