# Table Component

**URL:** <https://forum.inductiveautomation.com/t/table-component/6007>\
**Category:** Ignition\
**Created:** [March 11, 2013, 12:16pm UTC](https://forum.inductiveautomation.com/t/table-component/6007 "2013-03-11T12:16:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![epsmitas](https://avatars.discourse-cdn.com/v4/letter/e/4af34b/32.png) [@epsmitas](https://forum.inductiveautomation.com/u/epsmitas)\
**Post date:** [March 11, 2013, 12:16pm UTC](https://forum.inductiveautomation.com/t/table-component/6007/1 "2013-03-11T12:16:40Z")

</div>

Hi,

Re:Table Component

I am noticing that this query only returns “1” description column in the Table Customizer for “description”. I would like to rename each one individually. ( i.e. City, Province, Country ). Am I missing something here ? ( Version 7.3, Version 7.5 reports a “duplicate column”. )

SELECT  
supplier.name,  
supplier.“premise id”,  
supplier.contact,  
supplier.phone,  
province.description,  
country.description,  
city.description  
FROM  
public.city,  
public.country,  
public.province,  
public.supplier  
WHERE  
city.id\_city = supplier.id\_city AND  
country.id\_country = supplier.id\_country AND  
province.id\_province = supplier.id\_province;

---

<div class="post-metadata">

**Author:** ![epsmitas](https://avatars.discourse-cdn.com/v4/letter/e/4af34b/32.png) [@epsmitas](https://forum.inductiveautomation.com/u/epsmitas)\
**Post date:** [March 11, 2013, 1:10pm UTC](https://forum.inductiveautomation.com/t/table-component/6007/2 "2013-03-11T13:10:46Z")

</div>

Sorry… got it. Aliasing.

SELECT  
supplier.name,  
supplier.“premise id”,  
supplier.contact,  
supplier.phone,  
province.description as a,  
country.description as b,  
city.description as c  
FROM  
public.city,  
public.country,  
public.province,  
public.supplier  
WHERE  
city.id\_city = supplier.id\_city AND  
country.id\_country = supplier.id\_country AND  
province.id\_province = supplier.id\_province;