SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Insert join

  1. #1
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    Ireland
    Posts
    91
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Insert join

    Is it possible to insert data into two table with one statement like a join with select

    ie
    insert into module m, course_mod cm (m.mod_code, m.mod_title, m.coord_no, m.year, cm.mod_code ,cm.course_code) values ('com888', 'none', 122322, 1, 'com888', 'e410uj')

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,014
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    no
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •