两条SQL语句怎么写成一条
[A表]
Lidid
11
[B表]
Cidid
61
71
81
91
SELECT [Lid] FROM [A表] WHERE [id]=1
SELECT [Cid] FROM [B表] WHERE [id]=1
我要读出A表的[Lid]的字段值和B表的[Cid]的字段值
这两条SQL语句怎么写成一条
并得到的结果是
1
6
7
8
9
[解决办法]
SELECT [Lid] FROM [A表] WHERE [id]=1 union all
SELECT [Cid] FROM [B表] WHERE [id]=1
