This is really unorthodox and hopefully it's not anything in production. But, there a couple of ways to do this - one mentioned by
NeverJustHere - most accepted way of achieving your scenario.
Here are some ways I know (there are possibly more) would be:
1. Cartesian Product - basically matching every row in the first table with every in the second table. I don't know if this is what you need, since if you have 100 rows in the first table and 100 rows in the second table, it will give you 10,000 rows! To achieve this:
SELECT * FROM table1, table2
2. A union of the two tables.
SELECT column1, column2, etc FROM table1
UNION
SELECT column1, column2, etc FROM table2
You'll need to ensure that the column datatypes match up here.
3. Cross Join (as already mentioned)
SELECT table1.Column1, table2.Column1 FROM table1
CROSS JOIN table2 WHERE table.Column1 = 'Some value'
4. I would even say you could use an inner join as well with a condition that's true.
SELECT table1.Column1, table2.Column2 FROM table1
INNER JOIN table2 ON 1 = 1
Best bet would be to go with a cross join as already mentioned by another user.
Hope that helps!
SS