What I think is a quite simple SQL question

[slaterino]

Hi,

I am trying to do what I thought would be a simple SQL query but am having

some problems and can't find the answer to this on the web.

 

Put simply I want to add three values into a table using an append query. One

of those values I want to retrieve from another table and which is dependent

on a value on a form.

 

Okay, this is the start of my query:

 

INSERT INTO tbl_course_attendees_new ( URN, current, session_ID )

 

This first bit is fine. I then want to add a value from the form as well as

set 'current' which is a yes/no field to 'no.' So I have:

 

SELECT Forms!frm_search!URN AS URN, -1 AS current,

 

My problem is with the next bit which is that I want to find every value from

a table that has the same course_ID that is selected on the form in a drop-

down box. How can I add this to the query? The SQL statement for this alone

would be:

 

SELECT session_ID FROM sessions WHERE course_ID = Forms!frm_search!CourseName

 

How can I integrate that into the rest of the SQL query?

 

Thanks!

Russ

[TOA]

You'd get more help in the SQL thread, but don't start another, mods will probably move it and if not then I'm wrong.

 

If I understand you correctly, you might be looking for sub-queries