Stupid SQL Tricks

Argh. Classic Schroedinbug. I had an outer join between two tables to populate an InfoPath multi-select listbox. (So I needed a list of potential options with indications of which options had been selected). I created an outer join and put my parameter in the WHERE clause, like this: SELECT dbo.NeedRequestType.NeedRequestID,    dbo.NeedType.NeedTypeID,    dbo.NeedType.NeedType,    dbo.NeedCategory.NeedCategory FROM dbo.NeedCategory…

6