MySQL Query with INNER JOIN keep giving me an error - help needed

Unity Engine
1

I have two Tables - char_items and items. item_id is a common field among the two tables.

I want read the item_id from ‘char_items’ table and use that to obtain other information from the ‘items’ table based on that item_id. But my query is showing up as incorrect in MySQL. Please help –

SELECT * FROM char_items WHERE char_id=$char_id && isSlotted=1 INNER JOIN items ON char_items.item_id=items.item_id

I keep getting the message:

#1064 - 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 ‘INNER JOIN items ON char_items.item_id=items.item_id
LIMIT 0, 30’ at line 1

2

Figured out the mistake in my query. INNER JOIN comes way before WHERE :slight_smile: