--方式一:
SELECT UserID FROM UserTable WHERE ClientIp in (SELECT ClientIp FROM LoginTable WHERE USERID=1234)
UNION ALL
SELECT UserID FROM UserTable1 WHERE ClientIp in (SELECT ClientIp FROM LoginTable WHERE USERID=1234)
UNION ALL
SELECT UserID FROM UserTable2 WHERE ClientIp in (SELECT ClientIp FROM LoginTable WHERE USERID=1234)
UNION ALL
SELECT UserID FROM UserTable3 WHERE ClientIp in (SELECT ClientIp FROM LoginTable WHERE USERID=1234)
UNION ALL
SELECT UserID FROM UserTable4 WHERE ClientIp in (SELECT ClientIp FROM LoginTable WHERE USERID=1234)
SELECT UserID FROM UserTable WHERE ClientIp in @ClientIp
UNION ALL
SELECT UserID FROM UserTable1 WHERE ClientIp in @ClientIp
UNION ALL
SELECT UserID FROM UserTable2 WHERE ClientIp in @ClientIp
UNION ALL
SELECT UserID FROM UserTable3 WHERE ClientIp in @ClientIp
UNION ALL
SELECT UserID FROM UserTable4 WHERE ClientIp in @ClientIp
SELECT UserID FROM UserTable a,(SELECT ClientIp FROM LoginTable WHERE USERID=1234) b WHERE a.ClientIp =b.ClientIp
UNION ALL
SELECT UserID FROM UserTable1 a (SELECT ClientIp FROM LoginTable WHERE USERID=1234) b WHERE a.ClientIp =b.ClientIp
UNION ALL
SELECT UserID FROM UserTable2 a (SELECT ClientIp FROM LoginTable WHERE USERID=1234) b WHERE a.ClientIp =b.ClientIp
UNION ALL
SELECT UserID FROM UserTable3 a (SELECT ClientIp FROM LoginTable WHERE USERID=1234) b WHERE a.ClientIp =b.ClientIp
UNION ALL
SELECT UserID FROM UserTable4 a (SELECT ClientIp FROM LoginTable WHERE USERID=1234) b WHERE a.ClientIp =b.ClientIp
SELECT @SQL=
'SELECT UserID FROM UserTable WHERE ClientIp in ' +@ClientIp +
'UNION ALL '
'SELECT UserID FROM UserTable1 WHERE ClientIp in '+ @ClientIp +
'UNION ALL '
'SELECT UserID FROM UserTable2 WHERE ClientIp in '+ @ClientIp +
'UNION ALL '
'SELECT UserID FROM UserTable3 WHERE ClientIp in ' + @ClientIp+
'UNION ALL '
'SELECT UserID FROM UserTable4 WHERE ClientIp in '+ @ClientIp
谢谢.. 如果SELECT ClientIp FROM LoginTable WHERE USERID=1234查出来的结果放到一个临时表里,
然后按下面的代码会不会好点??
SELECT UserID FROM UserTable WHERE ClientIp in (SELECT ClientIp FROM 临时表)
UNION ALL
SELECT UserID FROM UserTable1 WHERE ClientIp in (SELECT ClientIp FROM 临时表)