#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    57
    Rep Power
    2

    Insert and Update HELP


    Hello,

    I am wondering if i can INSERT to a table then UPDATE another table in one query?

    So i will INSERT a row in a JIM, then
    UPDATE a row in BOB, then
    UPDATE a row in Tap Water.
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,204
    Rep Power
    4279
    sorry, nope, you need separate statements to do that

    Comments on this post

    • ide agrees : Thanks man! I kinda figure that but thanks for clarifing that up!
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo