What I think is a quite simple SQL question

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
slaterino
Forum Commoner
Posts: 46
Joined: Fri Jul 11, 2008 10:50 am

What I think is a quite simple SQL question

Post by 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
JakeJ
Forum Regular
Posts: 675
Joined: Thu Dec 10, 2009 6:27 pm

Re: What I think is a quite simple SQL question

Post by JakeJ »

Are you using MS Access?

While some of us here might know a thing or two about Access, you probably have a better chance of having your question answered if you go to an Access forum. Mostly we deal with PHP and MySQL here.
Post Reply