select s.id,s.name,e.sem from student as s, enroll as e where s.id = e.id;
select s.id,s.name,e.sem from student join enroll using (id);
so these 2 statements get the same result, but what is the difference? is there any case where they are not the same?
they are the same thing, one is the old style while the other saves some time and typing.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments