Wednesday, April 26, 2006

SQL weakness

One of my big weaknesses at work is SQL. I have been at the same job for almost 17 years. Unfortunately, my skills have been retarded due to the things that we do with our client software.

I was doing some things for a new piece of software today that uses a MSSQL for data persistence. I was doing a join on two tables, but I was not getting the results back that I expected. I finally figured out that I needed a “left join”, because not all of the records for one table had matching records in the joined table.

No comments: