[RESOLVED] join problem

[cbesh2]

I am having problems joining the following tables. I have attached an image to show the relationships. Any help is appreciated.

Also, below is the code that I have. (It is not working.)

...
INNER JOIN Size ON Products.sizeID=Size.sizeID
INNER JOIN Product-Theme_Relationship ON Products.prodID=Product-Theme_Relationship.prodID
INNER JOIN Theme ON Product-Theme_Relationship.prodID=Theme.themeID
...

Thanks again!

[tomhath]

Product-Theme_Relationship.prodID=Theme.themeID

Shouldn't that be themeID = themeID ? :eek:

[cbesh2]

Opps. Well, yes it should read themeID = themeID. But I'm still getting an error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-Theme_Relationship ON Products.prodID=Product-Theme_Relationship.prodID INNER J' at line 5

My corrected code (that still doesn't work) is:

...
INNER JOIN Size ON Products.sizeID=Size.sizeID
INNER JOIN Product-Theme_Relationship ON Products.prodID=Product-Theme_Relationship.prodID
INNER JOIN Theme ON Product-Theme_Relationship.themeID=Theme.themeID
...

[Lars_Berg]

If you have a hyphen in your table name you need to escape it

`Product-Theme_Relationship`

[cbesh2]

That was the problem. Thank you!!!!

NTM: No hyphens in table names.