Checking Syntax??

[bjm027]

I think I am in the right forum.

I have a SELECT statement in which I want to select two field names (ID, Email) from one table and I want ID to equal Request ID in another table and eventually be inserted into that table. Hope that makes sense.

Here is the sql (just checking the syntax on this statement):
-------------------
sql = "SELECT ID, Email FROM requests WHERE ID = " & Request.Form("RequestID&quot

 

[r937]

not really the right forum, you probably want microsoft access or sql server

and was there a question?

your query looks okay, by the way


rudy