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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org