怎么用sql将两个没关系的表查出来

[XiaoYi96]

比如biao1只有一条数据
字段A 字段B
A1 B1
biao2有两条数据
字段C 字段D
C1 D1
C2 D2

怎么查出这种效果
字段A 字段B 字段C 字段D
A1 B1 C1 D1
A1 B1 C2 D2

[doris_d]

select * from biao1, biao2;

[realweb]

select biao1.A1,biao1.A2,biao2.C1,biao2,C2 from biao1, biao2;

[exception92]

参见：https://blog.csdn.net/weixin_30881367/article/details/97593507
https://q.cnblogs.com/q/82900/

[Bridge_go]

select biao1.A1,biao1.A2,biao2.C1,biao2,C2 from biao1 full join biao2 on 1=1

[YBcsdn1996]

full join