MySQL simple JOIN query help

[creativodev]

I have 4 tables

car-audio

electronics

novelties

wheels-tires

 

they all have a column called caption. i want to make a query like this:

 

SELECT * FROM `wheels-tires`, `car-audio`, electronics, novelties WHERE caption LIKE "%apple%"

 

but it tells me its ambigous.

 

how can i fix it? im reading about inner joins and commands like that but can't come up with the right one.

 

please help.

 

[Barand]

I suspect that you really want a UNION in this instance, not a JOIN

 

SELECT id, caption, 'audio' as itemtype FROM car-audio WHERE caption LIKE '%apple%
UNION
SELECT id, caption, 'elec' as itemtype FROM electronics WHERE caption LIKE '%apple%
UNION
SELECT id, caption, 'nov' as itemtype FROM novelties WHERE caption LIKE '%apple%
UNION
SELECT id, caption, 'wheel' as itemtype FROM wheels-tires WHERE caption LIKE '%apple%