Good afternoon!
I have been a SQL Server D.B.A. for the past 7 years and am just now getting my feet wet with Postgres.
Could someone provide some help with this error?
ERROR: table name "ameren_sbc_attachments" specified more than once
-------------------
This is how I wrote the query: (and how I would have written it in Query Analyzer)
-------------------
UPDATE public.ameren_sbc_attachments SET Status = "ABANDONED"
FROM public.ameren_sbc
INNER JOIN public.ameren_sbc_attachments ON (public.ameren_sbc."UID"=public.ameren_sbc_attachments."FID")
WHERE
(public.ameren_sbc."Municipal" = 'ROYAL') AND
(public.ameren_sbc_attachments."Owner" = 'INSIGHT')
THANK YOU!
I have been a SQL Server D.B.A. for the past 7 years and am just now getting my feet wet with Postgres.
Could someone provide some help with this error?
ERROR: table name "ameren_sbc_attachments" specified more than once
-------------------
This is how I wrote the query: (and how I would have written it in Query Analyzer)
-------------------
UPDATE public.ameren_sbc_attachments SET Status = "ABANDONED"
FROM public.ameren_sbc
INNER JOIN public.ameren_sbc_attachments ON (public.ameren_sbc."UID"=public.ameren_sbc_attachments."FID")
WHERE
(public.ameren_sbc."Municipal" = 'ROYAL') AND
(public.ameren_sbc_attachments."Owner" = 'INSIGHT')
THANK YOU!