SQL INSERT question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to insert 3 columns into a table, the first column comes from a SELECT
from another table, the second and third columns are fixed values. Does
anyone know how to code this INSERT in SQL. I'm not using the query designer.
Thanks

So far I have:

strSQL = "INSERT INTO tblRuleDates (RuleID,DateTypeID,TargetDate)" & _
" (SELECT RuleID FROM tblPkgRuleXref" & _
" WHERE PkgID = " & lngPkgID & ")"
 
Where are the "fixed values" coming from? Are they memory variables?

strSQL = "INSERT INTO tblRuleDates (RuleID,DateTypeID,TargetDate)" & _
" SELECT RuleID," & lngDateTypeID & ", #" & datDateVal & _
"# FROM tblPkgRuleXref" & _
" WHERE PkgID = " & lngPkgID
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help in compile error 1
problem with joins 1
VBA - retrieve data on last create named range from previous inserted named range 0
How to join 4 tables with equi joins and left joins 1
syntax help for SQL where ????? And ?????????? 3
SQL Insert Value 2
Insert query 0
Insert data from SQL table into Access table 3

Back
Top