select distinct * from a left join b on a.id=b.aid and a.name='xxx' and b.name='yyy'
select a.* , m.* from a, (select t.* from b t where aid = (select min(aid) from b where name = t.name) ) m where a.id = m.aidselect a.* , m.* from a, (select t.* from b t where aid = (select max(aid) from b where name = t.name) ) m where a.id = m.aid
select
distinct *
from
a
left join
b
on
a.id=b.aid and a.name='xxx' and b.name='yyy'
(select t.* from b t where aid = (select min(aid) from b where name = t.name) ) m
where a.id = m.aidselect a.* , m.* from a,
(select t.* from b t where aid = (select max(aid) from b where name = t.name) ) m
where a.id = m.aid
通过aid,b表和a表关联
先通过name查询a表,如果b表的name匹配,也在查询结果中显示出来,且结果不重复
看不太懂你的具体意思.
select * from a join b on a.id=b.aid where a.name='abc' and b.name='abc'