I have the following new table
I receive a unique constraint error on the following insert
INSERT INTO ps_tr_ac_fmt_tbl
FROM ps_country_tbl@cehrdvl1 a,
WHERE a.country = b.country
AND a.country = c.country
AND c.cg_area_code <> ' '
AND effdt = (SELECT Max(effdt)
WHERE b.country = country
AND b.country_code = country_code)
AND b.eff_status = 'A');
The reason is that the ps_state_tbl has the following keys
Within the country, state on this table there are multiple entries for a description field.
(I.E. USA NY test
USA CT test )
Therefore I am bring back 2 rows for country, country_code and area_code into my new table
Is there anyway to combine the entries in the ps_state_tbl by country / description so I only
bring back 1 row into my insert ?
thanks in advance