Re: Query question
From: Gerald Stanley (gcstanley_at_d-s-l.pipex.comREMOVE-)
Date: 05/24/04
- Next message: MJ: "Re: Requery Combobox"
- Previous message: MacDermott: "Re: HOW CAN I VERIFY WHEN WITHDRAWING AN ITEM FROM A STORAGE IF IT EXISTS IN THE STORAGE?"
- In reply to: Hamoud: "Query question"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 24 May 2004 04:34:44 -0700
Try something along the lines of
SELECT YourFirstTable.[Name], YourSecondTable.CourseName
FROM YourFirstTable, YourSecondTable
WHERE YourSecondTable.CourseCode NOT IN (SELECT CourseCode
FROM YourThirdTable WHERE YourThirdTable.[ID] =
YourFirstTable.[ID])
You will have to changeth etable and column names to suit
your database.
Hope This Helps
Gerald Stanley MCSD
>-----Original Message-----
>Hi , There,
>
>I have created Training Database. The database contain 3
>tables as following :
>1- . First table contain the employees information such
>as ID, Name, Location,..etc. 2- Second one contains the
>courses that every employee must take and it's fields are
>CourseCode and CourseName.
>3- Third table contains the courses that already the
>employees have taken , and it's fileds are CourseCode
>only .
>
> I have made relationship with Employee table and
>the courses that they already have taken by ID. And
>relationship with table 2 and 3 by CourseCode.
>
> I want to make query to give me details about
>Employee information and the of courses that he not yet
>taken to enroll him in them.
>
> Actually I tried to use Unmatched query but it
>did not give me what I need.
>
> Would you , please help me
>
>Thank you Hamoud
>
>
>
>.
>
- Next message: MJ: "Re: Requery Combobox"
- Previous message: MacDermott: "Re: HOW CAN I VERIFY WHEN WITHDRAWING AN ITEM FROM A STORAGE IF IT EXISTS IN THE STORAGE?"
- In reply to: Hamoud: "Query question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
