[SQL] SQL Query Validate Records Multiple Tables - Help Needed

2007-05-19 Thread Paul251
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 i

Re: [SQL] SQL Query Validate Records Multiple Tables - Help Needed

2007-05-15 Thread Rodrigo De León
On May 15, 8:17 am, Paul251 <[EMAIL PROTECTED]> 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 valida