خرید بک لینک

Vote count: 1

I'm trying to add a new column in my family table called Full Address; It's basically combining values from other columns and generating the Full Address.

I wrote this query but it doesn't seem to be working. Alos, I would appreciate it if there's a better way to generate my desired value, Full Address.

update Family set FullAddress = select StreetAddress+', '+City+', '+State+', '+ZipCode AS Address from Family

Thanks

asked 1 min ago

1 Answer

Vote count: 0

Presumably, you just want this:

UPDATE Family
    SET FullAddress = StreetAddress + ', ' + City + ', ' + State + ', ' + ZipCode;

answered 54 secs ago

برچسب: update a column from a select statement,update column from select statement oracle, نویسنده: استخدام کار تاريخ: چهارشنبه 17 شهريور 1395 ساعت: 21:37

صفحه بندی