I have a question about How to insert and update data using Multiple tables . I need to insert data into two SQL table from one query ( insert statement ) and able to update that tables with a one update command . How do I do that . I think I have to use Inner jnoin but it is not working . Can any one give me the syntax of the SQL statement . I am using SQL server 2000 .