Paige,

For a start the union requires that the two select statments have the same number of columns and in their output. The first select is querying 4 column and the second only 3. The corresponding columns from each select in order to union them must also have the same datatype. Start with that and see what you get.