I have 3 table .a,b,c .The Name whose datatype is varchar .I need a query that will get one row from each table and give me a another table namely 'd'.This d will have 3 rows for eg. a1 above b3 above c2 ..these values in table d are random every time I run this query ..
when i run the query I need a table 'd' with random
and there is no relation between these tables !
asked May 09 '12 at 11:28 AM in Default
select (select top 1 name from @TableC order by newid())
answered May 09 '12 at 11:33 AM
Kev Riley ♦♦