Fetch from MySQL

Question

MySQL

SELECT
`plug_cat_sizes_join`.`item_id`,
`plug_cat_sizes_join`.`size_id`,
`plug_cat_colors_join`.`item_id`,
`plug_cat_colors_join`.`color_id`

FROM
`plug_cat_sizes_join`,
`plug_cat_colors_join`

JOIN `plug_cat_vals` as val 
ON val.`write_id` = `plug_cat_sizes_join`.`item_id` 
AND val.`write_id` = `plug_cat_colors_join`.`item_id`

Returns #1054 - Unknown column 'plug_cat_sizes_join.item_id' in 'on clause'
What's wrong?

Answer 1

Rewrite the query like this (it's better to join tables instead of trying to output them together):

SELECT
`plug_cat_sizes_join`.`item_id`,
`plug_cat_sizes_join`.`size_id`,
`plug_cat_colors_join`.`item_id`,
`plug_cat_colors_join`.`color_id`

FROM
`plug_cat_sizes_join`

JOIN `plug_cat_colors_join`
ON `plug_cat_colors_join`.`item_id` = `plug_cat_sizes_join`.`item_id`
JOIN `plug_cat_vals` as val 
ON val.`write_id` = `plug_cat_colors_join`.`item_id`

Answer 2

Clearly spelled the error