Query Multiple Tables

[Bobby_Jo]

I've done some searching, but can only find stuff on how to query multiple tables in which the tables have a column in common. What if you want to query multiple tables, but they have nothing common? For example:

table_1
column_dogs
column_cats

table_2
column_apples
column_oranges

If, on the page I need to display, I need information from column_dogs AND column_apples. Is there a way to do this in one query?

[aaron_karp]

SELECT column_dogs, column_apples FROM table_1, table_2

...should do the trick.