SQL INSERT Query Master Detail Table

  • Thread starter Thread starter W Dean
  • Start date Start date
W

W Dean

Hi,

I have two tables set up with a Master Detail relational and I want to set
up an INSERT Query which will only insert records into the Detail Table if
Certain criteria are met in the master table. For example, Insert these
Values into the detail table only if the master record was created by the
specified user.

I'm try to use the following and it reports a missing ; error

INSERT INTO CalenderPics (MasterID,ID,...) VALUES (aValue,aValue,...) WHERE
(CalenderPics.MasterID IN (SELECT Calender.CalenderID AS MasterID FROM
Calender WHERE Calender.UserName='Test3'))

Does anyone know the correct syntax for this query?

W Dean
 
Back
Top