Displaying 1 result from an estimated 1 matches for "dbo_region_terr".
2009 Jul 15
1
Help with RODBC connection to multiple MS SQL Sever databases
...m","WC_Reporting")
contab<-sqlTables(con)
region<-sqlQuery(con,'SELECT DISTINCT dbo_PATIENT.PATIENT, dbo_CONTRACT.CONTRACT, dbo_PATIENT.PATIENT_EPISODE, dbo_PATIENT.LAST_NAME, dbo_PATIENT.FIRST_NAME, dbo_CONTRACT.CON_STATUS, dbo_CONTRACT.CON_NUMBER, dbo_PATIENT.STATE, dbo_REGION_TERR.OPS_REGION, dbo_REGION_TERR.SPG_TERR, Sum(dbo_Line.total_ln_paid_amount) AS SumOftotal_ln_paid_amount
FROM dbo_CONTRACT
INNER JOIN dbo_REGION_TERR
RIGHT JOIN dbo_PATIENT
ON dbo_REGION_TERR.STA...