比如:
select s.name,c.name from student s left join course c on c.sid=s.sid
如果我要添加模糊查询条件,,可以在其后跟 and c.name=** 么?
select s.name,c.name from student s left join course c on c.sid=s.sid
如果我要添加模糊查询条件,,可以在其后跟 and c.name=** 么?
select s.name,c.name from student s left join course c on c.sid=s.sid
where c.name=**
我本来以为,on 就和where 一样,,,看来是我错了,,,谢谢