I have an
SQL statement like this,
SELECT * FROM (select "John" as FirstName Union All select "Mary" Union All select "Alis"), (select "Doe" as LastName union all select "Queen" union all select "Gunter") FirstName LastName John Doe John Queen John Gunter Mary Doe Mary Queen Mary Gunter Alis Doe Alis Queen Alis Gunter
This gives me a Cartesian, how do I get the following result,
FirstName LastName John Doe Mary Queen Alis Gunter
Any help would be great.