[A表]
Lid id
1 1
[B表]
Cid id
6 1
7 1
8 1
9 1
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