Resolved Question: Help with SQL Query. Help is really needed?

27 August 2011, 9:48 pm

I have two tables. One called Theater has the following information: Name City State Phone Great Escape 14, Wilder, KY, 8599933455 AMC Newport, Newport, KY, 8678979878 Esquire Theatre, Cincinnati, OH, 8978799876 The other called ShownAt has the following: TheaterName MovieTitle Great Escape 14, The Change-Up AMC Newport, Crazy, Stupid, Love AMC Newport, Final Destination 5 AMC Newport, Conan the Barbarian I have to create an sql query to do the following: Find the names and the phone numbers of theaters that do not show the movie "Crazy, Stupid, Love". I should get: Great Escape 14 8599933455 Anybody have any idea how to make this work?... Read More »

More Topics from "Answers"

• Resolved Question: Anyone in Northern Kentucky Wiccan?
• Resolved Question: What are some places that hire at the age of 14?
• Resolved Question: Covington/Newport, KY?
• Resolved Question: Are there any occult/wiccan shops in newport, ky?
• Resolved Question: Northern Kentucky places that DON'T i.d. for cigarettes?
• Voting Question: Are there any male and female strip clubs in Newport,KY and/or Cincinnati, OH?
• Resolved Question: How to meet new people to make friends with in cincinnati, oh?
• Resolved Question: Is this perfume still sold at Hot Topic or still being produced at all?
• Resolved Question: Cheap Hotels??? Near Cincinnati OH?