use select in Insert query IN LINQ RRS feed

  • Question

  • hi,
    i have two tables Student_master and Student details

    where in student_Master i have an primary key field which is stud_id
    now when ever i will insert data in Student_details the stud id must come from Student_maser


    insert Student_details (stud_id)values(select stud_id from Student_master where Stud_name="xyz")
    so plz reply fast.
    Wednesday, April 8, 2009 5:00 AM

All replies