Hi, I'm encountering problems with an sql statement, the problem occurs
with this line:
'and addresses.[direct address] = yes'
2 records are returned here, if I change it to
'and addresses.[direct address] = no'
again 2 records are displayed (different ones).. the strange thing is if I
run as:
'and addresses.[direct address] = yes or addresses.[direct address] = no'
This returns all records (as it should), but there's more than 4! (tens of
thousands of records to be precise)
So what's going on here? I'm hoping it's a common, simple slip-up that I can
easily fix!
Cheers,
Chris