Wise you are, Master Yoda!

In mysql, I used:

ALTER TABLE `artistsProducts` DROP `artistProductID`

ALTER TABLE `artistsProducts` ADD PRIMARY KEY (artistID,productID)

And viola! That is now my primary key. Thank you very...

Thanks again!

I'm almost un-confused, but not quite (bear with me, please):

I'm not going to need to relate this NN table to anything else, so yes, I agree that the identity...

Thanks Master Yoda!

In the artists table, artistID is the primary key and of course that's unique. In the products table, productID is the primary key, unique as well. ...

Hehe, nice curveball there, I'm on my toes now... thanks, Remi!!

- Dave

Thanks, I'm starting to follow you here, and I appreciate the move toward better syntax, but did you make a typo?

You said:

FROM artists inner join artistsProducts

on artists.artistID = artistsProducts.productID inner...