Re: SQL query help

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 Received on Thu Jun 10 2004 - 05:10:50 CDT