# Simple JOIN query help

**URL:** <https://forum.kirupa.com/t/simple-join-query-help/274352>\
**Category:** programming\
**Created:** [October 28, 2008, 8:28pm UTC](https://forum.kirupa.com/t/simple-join-query-help/274352 "2008-10-28T20:28:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![imagined](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@imagined](https://forum.kirupa.com/u/imagined)\
**Post date:** [October 28, 2008, 8:28pm UTC](https://forum.kirupa.com/t/simple-join-query-help/274352/1 "2008-10-28T20:28:59Z")

</div>

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.