I am attaching the three queries I have which are not finished yet. The JSON is the format that the app designers want. Please remember this is my first week learning SQL so I need time to get up to speed. I was just assuming I could output to JSON with the 2014 version. Once again thank you for your input.