Simple SQL question from a beginner...

[eluser]JanDoToDo[/eluser]
Hey so well for oneyou just said your tabls were p_id, C_id etc... but in your SQL you are using "profile_id" instead of "p_id"

Assuming that isnt the problem, this worksis this what you want??)

SELECT p.*, c.*
FROM `profile` p
INNER JOIN `category_line` cl ON p.`p_id` = cl.`p_id`
INNER JOIN `category` c ON c.`c_id` = cl.`c_id`
ORDER BY p.`p_id`;