Can I use sql to get data from different tables?

[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;