Thank george three for the advice, I have written it a different way then what you have in your post but I cannot get the view to stop displaying all...

Oh I forgot to tell you that I am using Oracle Express 10g. Don't know if that makes a differnce or not but by the book I have been studying...

That is a function we were taught for date and time in Oracle SQL. from my understanding date and time use the same Data type which is DATE in oracle....

Ok , but I have no Idea what you have just written. LOL. I have never seen a select statement yet with # symbols in it. SO I have no...

Thanks for the advice. Yes I an new to sql, been doing it for about a month now learning by mistakes along the way.

Ok thanks.

Yes I am using Oracle.

Thank you all for you help with this. I have learned some valuable things with ERD's from the comments eveyone has provided. Again thank you posters for the advice as...

Thank you all for the tips on my ERD. I thought I had it pretty much figured out b ut sometimes the foreign keys confuse me a little on where...