SELECT 1 AS ID,1 AS NAMEID1,2 as nameid2 into lxaGOselect * into lxb from ( select 1 as id,'李' AS NAME UNION ALL SELECT 2,'王' ) as tGOSELECT A.ID, (SELECT B.NAME FROM LXB AS B WHERE B.ID=A.NameID1) AS NAMEID1, (SELECT C.NAME FROM LXB AS C WHERE C.ID=A.NameID2) AS NameID2 FROM LXA AS A
SELECT 1 AS ID,1 AS NAMEID1,2 as nameid2 into lxaGOselect * into lxb
from
(
select 1 as id,'李' AS NAME
UNION ALL
SELECT 2,'王'
) as tGOSELECT A.ID,
(SELECT B.NAME FROM LXB AS B WHERE B.ID=A.NameID1) AS NAMEID1,
(SELECT C.NAME FROM LXB AS C WHERE C.ID=A.NameID2) AS NameID2
FROM LXA AS A