Can someone tell me what is wrong in this statement?
ReadBy1 = CASE WHEN (ReadBy1 IS NULL) THEN 1 END,
ReadBy2 = CASE WHEN (ReadBy1 IS NOT NULL AND ReadBy2 IS NULL AND ReadBy1<>1) THEN ReadBy2=1 END
(FromUserId = 1 OR ToUserId = 1)
AND (FromUserId = 15 OR ToUserId = 15)
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.
With just a little bit of SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form. If you have never written code or looked at an SQL statement before, no problem! ... give i…