Good Morning

I am in need of setting relations between several (3 or 4) SQL tables to perform an accurate query. Is this done with the JOIN command? Any help that you could give or pass to me would be greatly appreciated. Thank you