I have a query in which I have multiple clauses in the where clause:
When seperate everything works correctly but when I add in the AND operator I am not getting the correct result:
Am I missing something?
dbo.table1 a1 JOIN dbo.table2 a2 ON a1.[ID]=a2.ID
With the AND both WHERE clauses have to evaluate to TRUE for a result to be returned.
answered Aug 16, 2012 at 03:21 PM