Database

CONVERT(INT, ISNULL(P.ACTUAL_EXTENT, 0)) AS AREA,
CONVERT(INT,  ISNULL(P.IMPROVED_VALUE, -1)) AS OLD_MARKET_VALUE,

SELECT CONVERT(INT,  ISNULL(P.IMPROVED_VALUE, -1)) AS OLD_MARKET_VALUE
FROM SDE.PROPERTY_SUMMARY P

CONVERT(BIGINT,  ISNULL(P.IMPROVED_VALUE, -1)) AS OLD_MARKET_VALUE, 

strAggregateGroupFileName1 = "qryAggregationMatching"
strAggregateGroupSQLString1 = "SELECT tblGroupGLCodeMapping.GL_CODE, " & _
    "tblGroupGLCodeMapping.GL_CATEGORY, tblInputGroupFile.GL_AMOUNT " & _
    "FROM tblGroupGLCodeMapping INNER JOIN tblInputGroupFile " & _
    "ON tblGroupGLCodeMapping.GL_CODE = tblInputGroupFile.GL_CODE"
Set qdfLinkedTables = dbsBalanceSheet.CreateQueryDef(strAggregateGroupFileName1, _
    strAggregateGroupSQLString1)

'Still in VBA in MS Access
    strFileName = "qryAggregationGroupEntityMatching"
    strSQLString = "SELECT tblBSMappingGroup.COUNTRY, " & _
        "tblBSMappingGroup.ENTITY, tblBSMappingGroup.ACCOUNT_LABEL, " & _
        "tblBSMappingGroup.GL_CATEGORY, qryAggregationRollingTotals.ACTUAL " & _
        "FROM qryAggregationRollingTotals INNER JOIN tblBSMappingGroup ON " & _
        "qryAggregationRollingTotals.GL_CATEGORY=tblBSMappingGroup.GL_CATEGORY"
    Set qdfLinkedTables = dbsBalanceSheet.CreateQueryDef(strFileName , _
        strSQLString)

'Exports to CSV    
    strOutputCSV1Path = strOutputFilePath + " - Grouping File.xls"
    strMakeTableUpdateQuery = "SELECT qryAggregationGroupEntityMatching.ENTITY, " & _
        "qryAggregationGroupEntityMatching.ACCOUNT_LABEL, qryAggregationGroupEntityMatching.ACTUAL " & _
        "INTO tblExportCSV1 FROM qryAggregationGroupEntityMatching"
    DoCmd.SetWarnings False
    DoCmd.RunSQL (strMakeTableUpdateQuery)
    strReplacementOutputString = "csv"
    strNewOutputString = Replace(strOutputCSV1Path, _
        strRemovedOutputString, strReplacementOutputString)
    DoCmd.TransferText acExportDelim, "Standard Output", _
        "tblExportCSV1", strNewOutputString, False

Convert.Decimal(tblInputGroupFile.GL_AMOUNT, 2)

select table1.*,table2.*,table3.*<br />
from table1,table2,table3<br />
where table2.id = table1.id  and table2.id = table3.id

select t1.*, t2.*, t3.*
  from table1 t1
 inner join table2 t2 on t2.table1_id = t1.id
 inner join table3 t3 on t3.table2_id = t2.id
 where t1.field1 = <something>...</something>

Mika Wendelius wrote:

Do not delete messages after they are answered!

The idea is that people can find answers from these forums based on keywords in both questions and answers