两个表的关联查询
select c.custname,o.orderdate from customer c inner join orders o on c.custid=o.custid AND c.custname='青岛海尔电器' order by o.orderdate desc;
select o.orderdate,c.custname from customer c inner join orders o on o.custid=c.custid AND c.custname LIKE '%海尔%';
s
原创
2017-07-11 15:20:23 ·
1832 阅读 ·
0 评论