INSERT Query without FROM clause with WHERE clause

[jjames]

I am having a problem with the following Update query

INSERT INTO MyTable (Field1, Field2, Field3)
VALUES('Data1', 'Data2','Data3')
WHERE 'Data1' NOT IN (SELECT Field1 FROM MyTable)

It seems to expect a FROM clause but the data I want to insert does not come from a table, query, etc.

 

[r937]

VALUES contains a list of values

you have to hardcode them

if you don't want to include a value that exists in another query, then don't -- include it, i mean

you have to do this, i.e. not include it, yourself, when you prepare the list of values -- remember, they are hardcoded literal values

does that make sense?

if you do hardcode a value, it will get inserted

are you perhaps pulling data1, data2, data3 from some other place?

in that case, you don't want INSERT...VALUES syntax, you want INSERT...SELECT syntax


rudy

http://r937.com/