update query

[amillia]

do you guys see any obvious problems with this query.

UPDATE tbl_INSPECTIONS, Query3 INNER JOIN Query4 ON (Query3.PARA3 = Query4.TASK_NO1) AND (Query3.CARD1 = Query4.CARD_NO1) SET Query4.REQ_ID = tbl_INSPECTIONS.REC_ID;

 

[danvlas]

The resulting query must be updatable. If it's not, you won't succeed.

In your query, looks like you have a cartesian product between tbl_INSPECTIONS and Query3, which results in an non-updatable set.

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html