Skip to Content
Former Member
Nov 01, 2010 at 02:11 PM

Formatted Search Across Databases


Hi Expert,

I have a scenario where i have 2 databases lets say OEC Computers US and OEC Computers UK. I want to write a formatted search on OEC Computers US database to pick information from OEC Computers UK for instance picking customer code where my document number in OEC Computers UK is equal to the screen document number in OEC Computers US. I have started the query as below but still getting an error. Please assist.

SELECT a1.cardcode FROM SBODemoUK.dbo.ordr a1 WHERE a1.DocNum=$[ORDR.U_DelNo]