# Table Customizer Not Showing

**URL:** <https://forum.inductiveautomation.com/t/table-customizer-not-showing/4808>\
**Category:** Ignition\
**Created:** [July 12, 2012, 5:21pm UTC](https://forum.inductiveautomation.com/t/table-customizer-not-showing/4808 "2012-07-12T17:21:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jlr573](https://avatars.discourse-cdn.com/v4/letter/j/c6cbf5/32.png) [@jlr573](https://forum.inductiveautomation.com/u/jlr573)\
**Post date:** [July 12, 2012, 5:21pm UTC](https://forum.inductiveautomation.com/t/table-customizer-not-showing/4808/1 "2012-07-12T17:21:31Z")

</div>

When I added this SQL statement to the binding of my table, the customizer wont show when I click on it.

`
SELECT
	*
FROM
	work_order
JOIN 
	proj_state ON work_order.state = proj_state.id`

But if I remove the JOIN, the table customizer will show.  
I have Ignition 7.5 and Java 7 Update 5

---

<div class="post-metadata">

**Author:** ![James.Lorenz](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/james.lorenz/32/3290_2.png) [@James.Lorenz](https://forum.inductiveautomation.com/u/James.Lorenz)\
**Post date:** [July 12, 2012, 6:32pm UTC](https://forum.inductiveautomation.com/t/table-customizer-not-showing/4808/2 "2012-07-12T18:32:29Z")

</div>

It looks like the tables you’re joining have columns with the same name, is that correct? If so, you’ll want to use aliasing to give the ambiguous columns distinct names. Here is an example:

table names: table, table2  
column names that are the same in each table: item, item1

```auto
select 
	t1.item as i, t1.item1 as i1, t2.item as i2, t2.item1 as i3 
from 
	table as t1 
join 
	table2 as t2 on t1.id = t2.id
```

returns table with four columns: i, i1, i2, i3