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??