Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
WHERE clause disabling a LEFT JOIN?
I'm working on an SQL query for Access, and have come across an unusual problem. Basically, simplifying names to keep it more generic, the table I'm creating will look like this: Name |A1Count|A2Count|A3Count ------------------------------ GroupA| 0 | 3 | 4 | GroupB| 2 | 0 |...
