This is the place for advice and discussions 4 1. Sign in to vote. Hi I'm having a problem updating multiple columns in a table. PK However, it doesn't seem as though it's possible to 'SET' more than one column name - are there alternatives rather than writing separate update statements for each column?
PK Not sure if this makes sense but thanks for any replies. Thursday, September 25, PM. Friday, September 26, AM. Code Snippet. Viewed 80k times. Improve this question. Danny Beckett Use ' instead of " for SQL string literals — Andomar. You can't have 2 where clauses in 1 query. Thanks for your reply but when I am trying to execute this, it is showing error as missing operator. Add a comment. Active Oldest Votes. Improve this answer. Gordon Linoff Gordon Linoff 1. Sorry for incomplete question.
Yes, I am using Access for my query. Thanks again. Really Appreciated. You can delete the temporary table again when you're finished. BookingDetails bd on bd. I'm not sure given the original example there is a one to one or many relationship between BookingDetails and Shipment for bd. MyID to s. Example given has admittingly I'm assuming two different paramters for ids, so I'm assuming the potential for them to be differnet. I agree though that if an eplicit join exists it should be used!
Didn't even notice that, so perhaps the cross join is the better solution. Only the OP knows for sure. C B 1, 6 6 gold badges 17 17 silver badges 20 20 bronze badges. KenF KenF 5 5 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.
Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked 2. Related
0コメント