"gd91" <gilou91_at_free.fr> wrote in message
news:66d33996.0406100210.73186488_at_posting.google.com...
> Michael Austin <maustin_at_firstdbasource.com> wrote in message
news:<JUJxc.5193$hB6.411_at_newssvr23.news.prodigy.com>...
> > gd91 wrote:
> >
> > > hello
> > >
> > > i have 2 tables
> > >
> > > 1 obj :with 2 fields :code and category
> > > 2 evt :with 4 fields :seq_number,mp,object,status
> > >
> > > how to find all objects (obj_code) that have no expected maintenance
> > > (no seq_number with status = A)
> > > for a given maintenance plan (evt_mp)
> > > while the other objects of the same category have one for this mp.
> > >
> > >
> > > evt_object and obj_code can be join
> > ^^^^^^^^^^^
> > sounds like a school project to me ... so I will only give you a hint...
> > what is the foreign key on evt??
> >
> > Michael Austin.
>
>
>
> for evt table :
>
> PK is seq_number
>
> FK are object and mp
It was a HINT. YOU figure it out. No one here will do your homework for you.
If you write some SQL that you think may work, you may get some further
hints.
Received on Thu Jun 10 2004 - 13:17:32 CDT
