Can I use sql to get data from different tables?

[FNC]

I currently have:

sql="select data from tablename"

But I need to go to another table and get records with data.

Can this be done or do I need 2 different sql statements??

[crptcblade]

SELECT Table1.Price, Table2.Location FROM Table1, Table2

[Lethal]

It's called "Joining Tables". There's ton's of information out there on this subject.

[jim mcnamara]

You can also create a view (a query, depending on the db you're using).

ansi sql view creation:
Create View MyView as select one, two,three from tableA, tableB
where tableA.four = tableB.four;

You then just say:

Select * from MyView;