I am trying to reproduce a query that was written with a Oracle DB and am trying to reproduce it in Access the query is as follows:
strSql = "select a.param_value, b.datapoint_id from " & _
"epa.epa_testdata a, epa.epa_engtemp b where a.param_id (+) = " & _
mintID & " and a.datapoint_id (+) = b.datapoint_id and " & _
strUidConst
the param_value is sometimes null and the only way that I can get it to return a null in Access with a really ugly union query that is way to slow to use. This is killing me since I cant get Access to return a null with out using the union any help out there?
Thanks in Advance
strSql = "select a.param_value, b.datapoint_id from " & _
"epa.epa_testdata a, epa.epa_engtemp b where a.param_id (+) = " & _
mintID & " and a.datapoint_id (+) = b.datapoint_id and " & _
strUidConst
the param_value is sometimes null and the only way that I can get it to return a null in Access with a really ugly union query that is way to slow to use. This is killing me since I cant get Access to return a null with out using the union any help out there?
Thanks in Advance
