SQL

Simple select 

Select * from [tableName];

Select with filter

select * from [tableName] where [col1] = [x];

Join

select 

from [tabA] a

join [tabB] b on a.[col1] = b.[col1];

Update

Update based on 2 tables