So I'm learning SQL and right now I'm working on properly understanding joins. I was wondering if I had the following right:<BR><BR>1) Inner Joins are associative and commutative.<BR><BR>2) Left Outer ...

I have to write a query on a positively atrocious table (this is with MSSQL 2005). Basically, multiple "lists" are stored in a single gigantic table called "UserData". I'm building the SQL statement ...