I have been working with a lot of SQL lately. I wouldn't label myself an expert, but I have been finding my way around a lot easier the more I work with it. I have been working a lot with normalizing data and writing queries that reference multiple tables. When referencing multiple tables, it is common to write a join. Here is a very small overview that explains the difference … [Read more...] about What is the difference between LEFT, RIGHT, INNER and OUTER JOIN?
Archives for June 2013
Paste to Terminal in Linux | Paste to cmd.exe Windows
This is not a very long article, but hopefully it rises to the top quick and is helpful. How to Paste to Terminal in Linux Answer: SHIFT+Insert How to Paste to cmd | command in Windows Answer: ALT+SPACE,e,p The windows command really just keystrokes the menu. There is a hotkey fix method that you could check out at lifehacker. That's all I have for this article. Please … [Read more...] about Paste to Terminal in Linux | Paste to cmd.exe Windows
SQL QUERY | Sum Values by Group in Access 2010
I have been working with Access a lot lately. In my last project I was working with a table that contained 1.4 million records with count values by US States. I needed run a graph based on the sum of values for each state. My original table looked like this: Table: States State Value MN 54 MN 62 IL 76 MN 34 CA 48 MN 62 IL 4 And so on... All of the way … [Read more...] about SQL QUERY | Sum Values by Group in Access 2010