Simple Sample Cose relationship between table id to Document id
SELECT TOP 1234 a.[arcId]
,a.[S3]
,a.[S4]
,a.[D1]
,a.[M1]
,a.[N2]
,b.[arcDocumentId], b.[arcFileName], b.[arcOrgName],b.[arcPageCount]
FROM [TABEL_NAME].[dbo].[tblDocuments] a,[TABEL_NAME].[dbo].[tblFiles] b where a.arcId = b.arcDocumentId
0 comments:
Post a Comment