Validate a Field in 2 seperate DB ??

[isitreel]

I am trying to validate a asset number (10 Characters) from one table (Asset DB)to another table (Inventory DB). 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 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

[isitreel]

Here is what I have been working with to validate the Feeder number is a valid number from table 2... So basically table 1/DB1 will validate against Table2/DB2 and if the reocrd is a valid value in Table2/DB2 update the flag to Y if not valid in Table2/DB2 update the flag to N..


UPDATE WEBDB1..VDEPLOYMENT_PLAN
SET VALID_FEEDER='N'
WHERE NOT EXISTS(SELECT FEEDER_NUMBER FROM WEBDB5..FEEDER_HEAD t2 WHERE
t2.FEEDER_NUMBER=WEBDB1..VDEPLOYMENT_PLAN.FEEDER_N O)