A few issues...
1) "WHERE B.Price > '10'" Assuming the Book.Price field is numeric, you don't use the single quotes (single quotes are used with char/varchar fields). In effect, you're trying to compare a numeric value to a string.
2) "was published in Boston" I don't see anything in your query checking for Boston.
3) "UNION" I don't know why you would need a UNION operator to do this query. Using OR in the WHERE clause should work nicely.

This should point you in the right direction. Since it's your homework, I don't want to give too much away. :)

Here is a revised version.

SELECT B.BookCode, B.Title
FROM Book B
WHERE B.Price > 10
UNION
SELECT B.BookCode, B.Title
FROM Book B, Publisher P
WHERE P.City = 'Boston'
AND B.PublisherCode = P.PublisherCode;

However, this only displays books more than $10, not the ones from Boston. I'm not 100% sure it has to be a UNION. The section before that was JOIN, IN & EXISTS.

What do you get with just

SELECT B.BookCode, B.Title
FROM Book B, Publisher P
WHERE P.City = 'Boston'
AND B.PublisherCode = P.PublisherCode

Also, consider if you really need to use UNION at all. How would you write it if you couldn't use UNION?

[edited by: LifeinAsia at 11:25 pm (utc) on Apr 27, 2010]

I guess its kind of a stupid question, because after further looking, ALL of the Boston books (only 2 of them), are both more then $10. I guess I have found the solution! Thanks for the help.

Actually, it's not that stupid of a question. If you do the same query with UNION ALL instead of just UNION, you'll find that the result includes duplicates (in other words, all the result of the first part with all of the result from the second part, without duplicates being removed).

And your price for help- try writing the query without using UNION. :)

Thanks for the tip.

As far as not using UNION, maybe something like this?

SELECT B.BookCode, B.Title
FROM Book B, Publisher P
WHERE B.Price > 10
AND P.City = 'Boston'
AND B.PublisherCode = P.PublisherCode;

If I wanted to change the original question from OR to AND, would I still use UNION?

WHERE B.Price > 10
AND P.City = 'Boston'

Well, this will give you the same results for this particular data set. But remember that you want all the books over $10 OR printed in Boston. Hint, hint. :) This should also answer your question about using still using UNION.

By the way, you CAN use UNION as you did in your original example. My feeling is that it would be less efficient because the table has to be queried twice. However, if the instructor is one of those "The chapter was about using UNION, so you have to use UNION" types... :) In fact, when I was learning SQL, I seem to remember a similar homework problem. The prof made a comment that he wouldn't take any points off for using a UNION, but recommended that we do things more efficiently in the real world.

Personally, about the only times I use UNION is when I need to get similar data from 2 separate tables. Something like (find all the books or toys costing more than $10):
SELECT Toys.Item
FROM Toys
WHERE Toys.Price > 10
UNION
SELECT Books.Item
FROM Books
WHERE Books.Price > 10