SQL联合查询:子表任一记录与主表联合查询

今天有网友群里提了这样一个关于SQL联合查询的需求:

SQL联合查询:子表任一记录与主表联合查询

一、有热心网友的方案:

SQL联合查询:子表任一记录与主表联合查询

二、我的方案:

select * from (
select a.*,(select top 1 Id from B as b where b.CgId =a.ID)as bid
from A as a
) as temp left join B as b2 on temp.bid=b2.Id

上一篇:AngularJs学习笔记--Understanding the Model Component


下一篇:centos7 docker安装mysql