DECLARE @a TABLE(id int) INSERT @a SELECT 1 UNION ALL SELECT 11 UNION ALL SELECT 13DECLARE @b TABLE(id int) INSERT @b SELECT 21 UNION ALL SELECT 53 UNION ALL SELECT 9SELECT TOP 1 id FROM( SELECT *,idx=1 FROM @a UNION ALL SELECT *,idx=2 FROM @b ) x ORDER BY idx,NEWID()
INSERT @a SELECT 1 UNION ALL SELECT 11 UNION ALL SELECT 13DECLARE @b TABLE(id int)
INSERT @b SELECT 21 UNION ALL SELECT 53 UNION ALL SELECT 9SELECT TOP 1 id FROM(
SELECT *,idx=1 FROM @a
UNION ALL
SELECT *,idx=2 FROM @b
) x
ORDER BY idx,NEWID()