March 28th, 2017, 01:17 AM
I have a table with a foreign key X and another column, Y.
If there is only ONE row with the foreign key X, and the column Y in that row is a certain value, I want to update column Y to a different value.
Can this be done with one query?
March 28th, 2017, 02:51 AM
including a check to confirm that there's only one row?
Originally Posted by Arty Zifferelli
March 29th, 2017, 06:31 PM
Well, yes. I don't think it's possible, but I'm not an SQL guru, so I thought I'd ask...
March 30th, 2017, 03:05 AM