Is this a VALID query ???

I'm using ASP to run a query against an oracle database, but it reports an invalid column name...typically I know this is usually a misspelling or something...But I wanted to verify that you can do a JOIN with other criteria in the WHERE clause with an UPDATE query...

So is this query properly structured? Thanks in advance!

SQLStmt = "update repair "

SQLStmt = SQLStmt & "set repair_action_code = '" & action & "', "

SQLStmt = SQLStmt & "repair_cause_code = '" & cause & "', "

SQLStmt = SQLStmt & "part_number = '" & part & "', "

SQLStmt = SQLStmt & "reference_designator = '" & reference & "' "

SQLStmt = SQLStmt & "where product_event.event_id = " & session("event_id_repair") & " "

SQLStmt = SQLStmt & "and product_event.assembly_serial_number = '" & session("serial_number_repair") & "' "

SQLStmt = SQLStmt & "and product_event.event_id = repair.event_id "

SQLStmt = SQLStmt & "and repair.repair_action_code = '" & old_action & "' "

SQLStmt = SQLStmt & "and repair.repair_cause_code = '" & old_cause & "' "

SQLStmt = SQLStmt & "and repair.part_number = '" & old_part & "' "

SQLStmt = SQLStmt & "and repair.reference_designator = '" & old_refdes & "' "

Set RS = Connection.Execute(SQLStmt) Received on Tue Apr 25 2000 - 00:00:00 CDT