SQL Server - I need to create a single table, with two rows, from two single row tables.

Asked By Al on 15-Feb-13 03:30 PM
Each row in the result table should contain a match of each entry in one table with each entry in the other table.

How can I write code to create this table from the two tables I already have?

Thanks!

(And, in the heading, I meant "COLUMN" not "ROW". )