Re: ok, i need help

ok,

thank you for all your help. it was most appreciated.

jerry

Jerry Parmeley <jparmeley_at_hotmail.com> wrote in message news:t8c28e88145l8b_at_corp.supernews.com...
> everyone out there in sql land, i need help.
> for a school project we are creating a airline company database.
> this database should include airports (5), jets (3), passengers (20), and
> flights (20-arriving and departing).
> i have created the data within the database; however, i can not get select
> statements to work. simple statements like selecting column from table no
> problem. but when it come to complex statements it won't work for me. i
> guess i am not getting the idea of joining. example select that returns
 no
> rows
>
> select flightdepart_id, jet_id, airport_id
> from flightdepartureinfo
> where flightdepartdaytime = to_date('22-Jun-2005 dd-mon-yyyy');
>
> doesn't work, i do have a flight that leaves on the 22 of june.
>
> i need some help, even the sql dummies book i bought isn't helping a whole
> lot of these silly joins. it would help if the teacher taught us sql, but
> he expects us to learn it ourselves.
>
> thanks for the help
>
> jerry
>
>
Received on Thu Feb 15 2001 - 05:57:53 CET