Member Avatar for denmarkstan
denmarkstan 0 Junior Poster in Training

pls brothers help me out here:

"INSERT  INTO finaldata (Hall, Bedspace, AmountPaid) SELECT * FROM AllcDataBoys 'WHERE Bedspace ='" + (Bespx.CompareTo(RET) == 0) + "'WHERE RegNumber ='" + txtRegNumber.Text.Trim().ToString();

finaldata table has 7 columns and AllcDataBoys table has 3 columns(which is common on both tables).
i want to get a specified row from AllcDataBoys table where (Bespx.CompareTo(RET)==0)and put them in finaldata where txtRegNumber match any RegNumber data where the 3 columns exit among the 7 column in finaldata table. -- the error it gives: incorrect syntax!

Bespx is AllcDataBoys table data while RET is parameter that is passed to method container of the sql code above. pls brothers help brother.

  • 1 Contributor
  • 0 Replies
  • 67 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.