I have 4 tables
[LIST]
[]car-audio
[]electronics
[]novelties
[]wheels-tires
[/LIST]
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.
