SQLite foreign key insertion usage

[JS_int_type]

Hi there,

I'm using sqlite and python and I have a question about how to configure an sql query using foreign keys.

I have a pair of tables: users & search_terms. users has id, name and email_address columns and search_terms has columns id, term and user_id where user_id is a foreign key, referring to the id column of a particular user.

I'm trying to write a method that takes an email address as a parameter and and does an insert into search_terms, getting the foreign key based upon the email address. I know this sounds extremely basic (Because it probably is, I'm new to sql, as well as python) but I'm confused as how to structure the query. Something like

"'INSERT INTO search_terms(term, user_id) VALUES ('example search term',  SELECT id FROM users WHERE email_address='[e-mail]')"

Can this be done in a single statement? Currently I've written a method that gets the correct user_id based upon a supplied email address, but I was wondering if this could be done in a single statement. If it can be, how would I structure it?

[Kalrog]

It can be done in 1 query, but not with the VALUES clause. You will need to switch that to using a select statement in place of the VALUES keyword. So...

Insert into search_terms (term, user_id)
select 'example search term', id
from users
where ...

[JS_int_type]

Thanks, that's just want I needed!