How to use Join?

[jovcem]

I have searched and havent found how to use JOIN in a sql string? Is that possible, and are there examples somewhere.
Thanks

[jovcem]

Nevermind, I forgot to use comma. Here is query:

const res = await sql` 
		select
			p.img_url,
			c.name
		from mars_rover_photos p
		join mars_rover_cameras c
		on p.camera_id = c.id
	`