Re: SQL Query Validate Records Multiple Tables - Help Needed

On May 15, 8:17 am, Paul251 <savethe(dot)(dot)(dot)(at)gmail(dot)com> wrote:
> Hello...
>
> I am trying to validate a asset number (10 Characters) from one table
> to another table. Problem is they are in two different DB's and
> haven't done that before?
>
> Basically trying to take record 1 from Table 1/DB1 and validate it
> against record 1 in Table 2/DB2 if the record doesn't exist in Table 2/
> DB2 update the flag to N in Table 1/DB1..... Seems easy but been
> working on it for about a week now no luck.... :-( I have the mostly
> the same colums in both tables but Table 2/DB2 is the host table I
> need to verify from....
>
> Does anyone have any help or code to help me do this??
>
> Thanks

See:

http://www.postgresql.org/docs/faqs.FAQ.html#item4.17

https://projects.commandprompt.com/public/pgsql/browser/trunk/pgsql/contrib/dblink/doc/query?rev=26230