select B from tb 该语句返回n行
B1
B2
B3
...
BNselect A,C form ta 该语句返回,肯定只有一行
A,C我现在想要得到如下格式的select
A,B1,C
A,B2,C
A,B3,C
...
A,BN,C请问如何写select语句?
B1
B2
B3
...
BNselect A,C form ta 该语句返回,肯定只有一行
A,C我现在想要得到如下格式的select
A,B1,C
A,B2,C
A,B3,C
...
A,BN,C请问如何写select语句?
select a.A,b.B,a.C from tb a cross join ta B
select
b.A,a.B,b.C
from tb a
cross join ta b
select ta.a,tb.b,ta.c
from ta cross join tb具体参考帮助里的"cross join"
上学时了解过SQL语句,但从没写过,知道有个join,基础太不扎实了