Parenteser omkring AND statement i MS Query
HejJeg er ved at lave en søgning ned i vores BMC Remedy database. Jeg bruger en ODBC driver og MS Query til at hente data ind i Excel.
Når jeg vil lave denne søgning:
-------------------------------------------------------
SELECT Change_data_180_dage.Infrastructure_Change_ID, Change_data_180_dage.Change_Request_Status, Change_data_180_dage.Change_Request_Status
FROM Change_data_180_dage Change_data_180_dage WHERE
(
(Change_data_180_dage.Status_History_Draft_TIME<{ts '2012-01-04 11:00:00'}) AND (Change_data_180_dage.Status_History_Completed_TIME>{ts '2012-01-04 11:00:00'})
)
OR
(
(Change_data_180_dage.Status_History_Draft_TIME<{ts '2012-01-04 11:00:00'}) AND (Change_data_180_dage.Status_History_Completed_TIME Is Not Null) AND (Change_data_180_dage.Status_History_Closed_TIME>{ts '2012-01-04 11:00:00'})
)
OR
(
(Change_data_180_dage.Status_History_Draft_TIME<{ts '2012-01-04 11:00:00'}) AND (Change_data_180_dage.Status_History_Cancelled_TIME>{ts '2012-01-04 11:00:00'})
)
OR
(
(Change_data_180_dage.Status_History_Draft_TIME<{ts '2012-01-04 11:00:00'}) AND (Change_data_180_dage.Status_History_Rejected_TIME>{ts '2012-01-04 11:00:00'})
)
OR
(
(Change_data_180_dage.Status_History_Draft_TIME<{ts '2012-01-04 11:00:00'}) AND
(Change_data_180_dage.Change_Request_Status<>'Completed') AND
(Change_data_180_dage.Change_Request_Status<>'Closed') AND
(Change_data_180_dage.Change_Request_Status='Cancelled') AND
(Change_data_180_dage.Change_Request_Status='Rejected')
)
---------------------------------------
Laver MS Query den om til:
----------------------------------------------
SELECT Change_data_180_dage.Infrastructure_Change_ID, Change_data_180_dage.Change_Request_Status, Change_data_180_dage.Change_Request_Status
FROM Change_data_180_dage Change_data_180_dage WHERE (Change_data_180_dage.Status_History_Draft_TIME<{ts '2012-01-04 11:00:00'}) AND (Change_data_180_dage.Status_History_Completed_TIME>{ts '2012-01-04 11:00:00'}) OR (Change_data_180_dage.Status_History_Draft_TIME<{ts '2012-01-04 11:00:00'}) AND (Change_data_180_dage.Status_History_Completed_TIME Is Not Null) AND (Change_data_180_dage.Status_History_Closed_TIME>{ts '2012-01-04 11:00:00'}) OR (Change_data_180_dage.Status_History_Draft_TIME<{ts '2012-01-04 11:00:00'}) AND (Change_data_180_dage.Status_History_Cancelled_TIME>{ts '2012-01-04 11:00:00'}) OR (Change_data_180_dage.Status_History_Draft_TIME<{ts '2012-01-04 11:00:00'}) AND (Change_data_180_dage.Status_History_Rejected_TIME>{ts '2012-01-04 11:00:00'}) OR (Change_data_180_dage.Status_History_Draft_TIME<{ts '2012-01-04 11:00:00'}) AND (Change_data_180_dage.Change_Request_Status<>'Completed' And Change_data_180_dage.Change_Request_Status<>'Closed' And Change_data_180_dage.Change_Request_Status='Cancelled' And Change_data_180_dage.Change_Request_Status='Rejected')
------------------------------------------------------
Som ikke giver det samme resultat.
Hvordan kan jeg sikre at parenteserne omkring min AND statements bliver der??
På for hånd tak.