Re: SQL query help

From: Michael Austin <maustin_at_firstdbasource.com>
Date: Wed, 09 Jun 2004 19:53:13 GMT
Message-ID: <JUJxc.5193$hB6.411@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. Received on Wed Jun 09 2004 - 14:53:13 CDT