New-B need help with SELECT. JOIN. WHERE

I don't know how to use WHERE with JOIN

[erroronexit]

I have a little MySQL query that works well:

SELECT * FROM parts
JOIN bom ON parts_idparts = idparts
LIMIT 250

Does exacly what I want, well, so far. Now I like to filter the data from 'parts' with a FORM.

I like to squeeze in the string:

WHERE
type LIKE '%{$_POST['such']}%' OR 
description LIKE '%{$_POST['such']}%' OR
value LIKE '%{$_POST['such']}%' 

How I can use this?

[LifeinAsia]

You just need to scope any ambiguous columns. FOr example:
SELECT *
FROM parts
JOIN bom ON parts_idparts = idparts
WHERE parts.type LIKE '%{$_POST['such']}%' OR
parts.description LIKE '%{$_POST['such']}%' OR
parts.value LIKE '%{$_POST['such']}%'
LIMIT 250