arthurh88
asked on
Trying to combine 2 Select statetments
SELECT TOP (1) F1
FROM WordList
WHERE (F1 > '')
ORDER BY NEWID()
SELECT TOP (1) F2
FROM WordList
WHERE (F2 > '')
ORDER BY NEWID()
I want to take both of those select statements and combine them so that the results are two colums with one row.
FROM WordList
WHERE (F1 > '')
ORDER BY NEWID()
SELECT TOP (1) F2
FROM WordList
WHERE (F2 > '')
ORDER BY NEWID()
I want to take both of those select statements and combine them so that the results are two colums with one row.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.