Re: ok, i need help

Most likely you have a time in your flightdepartdaytime. In Oracle any date part you don't specify is derived from the system clock. So you either need to use
trunc(<date column>) = 'literal constant' or
<date column> between trunc(to_date('literal_constant') and to_date('literal constant'||'23:59')

As 'silly joins' are the essence of sql, you should learn to live with them

Hth,

Sybrand Bakker, Oracle DBA

"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 Sun Feb 11 2001 - 08:49:02 CET