weixin_39658966的博客 v_sql := 'create table ' || v_tablename || 'as select s.jsq,s.dwm,s.bmdm,s.tbr,s.xm,s.shbzh,min(jsq)as jsq,t.dwm,t.tyymd,t.txymd from shffjl s left join txda t on s.tbr = t.tbr group by s.jsq,s.dwm,s...
失去梦想变成大咸鱼的博客连接模糊查询(左连接示例) SELECT s.*,c.*,o.* FROM student s LEFT JOIN sc c ON s.sid = c.cid LEFT JOIN course o ON o.oid = s.sid WHERE s.sdept LIKE "%c%" 新手菜鸟一枚,如有错误的地方还请大神指教~~