How to do a JOIN

[earthlingzed]

I still don't grasp how to do a join and would like someone to school me. Nothing I have read on MySQL.com or in books is getting through my head.

I have two tables as follows (one stores info about some products, the other stores artist info who have created the products):

oneofakind_items
prodid (PK)
artistid
title
desc
price
itemphoto
dateadded

oneofakind_artists
artistid (PK)
firstname
lastname
email
photo
symbol
username
password
statement

How can I write some SQL to query the DB asking for the two tables to be combined so I can display the artist info next to a particular item?

[Roger_Ramjet]

$sql = "SELECT * FROM oneofakind_artists
           INNER JOIN oneofakind_items 
           USING(artistid)"

$sql = "SELECT * FROM oneofakind_artists AS a
           INNER JOIN oneofakind_items AS i 
           ON a.artistid=i.artistid"