SQL Help (for class)

[pleifer 0]

HELLPP!!! I have spent 3 hours on this one friggin problem and tried everything i know (which is admitidly not much when it comes to sql) but this should be basic stuff.

I am coming up with some really wierd results, there is only 2 records in the reservation table, although anything I try gives me 13 to 300 records

am at my wits end with this problem, the question is

For all videos currently being reserved (i.e., those in the Reservation table), show the corresponding customer name (last and first) and zipcode, as well as the corresponding store address (street, city, state, zipcode) and manager.

and my imput:
SELECT movie.title, customer.lastname, customer.firstname, customer.zipcode, store.*
from customer, store, reservation, movie
where reservation.accountid

HELP PLLLEEZZZEEE

_________________________________________
The Angel of Duh has spoke

[dmace 0]

try this;

SELECT movie.title, customer.lastname, customer.firstname, customer.zipcode, store.*
from customer customer,
store store,
reservation res,
movie movie,
video vid
where customer.accountid = res.accountid
and res.videoid = vid.videoid
and vid.storeid = store.storeid
and vid.movieid = movie.movieid

[pleifer 0]

Dude you sooooo rock!!!!!!!

thanks, I see what you did now, i can do the rest of the assignment

THanks!!!!

_________________________________________
The Angel of Duh has spoke

[ianmdrennan 2]

Quote

from customer, store, reservation, movie

Avoid this and use joins that correlate to the referential integrity rules of the database.

Blues,
Ian

Performance Designs Factory Team