selecting from two tables

[ghandi]

i'm a newbie.

i want to select from two different tables but i have no clue how to do so. if you can give me an example that would be great. thanks ahead.

[Anon]

first thing is to make sure the tables are linked by some common field and in the same database (of course), then:

SELECT * FROM table1, table2 WHERE field.table1 = field.table2