Member Avatar for denmarkstan

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 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!

Edited by happygeek because: Removed TEX tags so people can actually read the question!
  • 2 Contributors
  • 1 Reply
  • 74 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by brandonrunyon
Member Avatar for brandonrunyon

what syntax are you using (since that is the concern)? And what database are you using? We can't examine your query if we don't have a place to start.

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.