Table Component

Ignition
1

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;

2

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;