27,579
社区成员
发帖
与我相关
我的任务
分享
select a.a列,b.c列,b.c列,b.a列 from A a
join B b on 1=1 --两表关联条件
where a.a列=‘产品名称’ and b.c列=‘被单号’
select cola,colc from(
select a.cola,row_number()over(order by getdate())as num from tbla a) m
left join(
select b.colc,row_number()over(order by getdate())as num from tblc b)n
on m.num=n.num
select a.a列,b.c列 from 表A a,表B b where a.id=b.id
或者
select a.cola,b.colc from tbla a inner join tblb b on a....=b....
select a.a列,b.c列 from 表A a,表B b where a.id=b.id