SELECT DES_DECRYPT(User,'rayo') AS User,
       DES_DECRYPT(Password,'rayo') AS Password,
       DES_DECRYPT(Name,'rayo') AS Name,
       DES_DECRYPT(LastName,'rayo') AS LastName,
       DES_DECRYPT(eMail,'rayo') AS eMail,
       DES_DECRYPT(Type,'rayo') AS Type 
FROM Security.Users;


DROP USER IF EXISTS `carlo`@'localhost';
DROP USER IF EXISTS `carlo`@'%';


        sSQL_ = "CREATE TEMPORARY TABLE " & sTemporary & " " & _
                "SELECT DES_DECRYPT(User,'" & sAPass & "') AS OldUser," & _
                       "DES_DECRYPT(Name,'" & sAPass & "') AS OldName, " & _
                       "DES_DECRYPT(Type,'" & sAPass & "') AS OldType, " & _
                       "SPACE(40) AS User, SPACE(40) AS Name, SPACE(10) AS Type FROM " & sT_ & ";" & _
                "UPDATE " & sTemporary & " SET User = OldUser, Name = OldName, Type = OldType;" & _
                "SELECT A.User,B.Name FROM " & GVar.sT_AuthorizedCompanies & " A " & _
                    "LEFT JOIN " & sTemporary & "  B " & _
                    "ON A.User=B.User " & _
                    sW_ & "ORDER BY Name;"



        Dim sSQL_ As String = "SELECT '1' AS 'A/E',A.System,A.CompanyID,A.User,A.Program AS P_ID,TRIM(B.MenuItem) AS MenuItem " & _
                              "FROM " & sAuthorizedPrograms & " A " & _
                              "LEFT JOIN " & sPrograms & " B ON A.System=B.System AND " & _
                                                               "A.Program=B.Code " & _
                              "WHERE A.System='" & sSys_ & "' AND " & _
                                    "A.CompanyID='" & sCia_ & "' AND " & _
                                    "A.User='" & sU_ & "' " & _
                              "UNION " & _
                              "SELECT '0' AS 'A/E',A.System,A.CompanyID,A.User,A.Program AS P_ID,TRIM(B.MenuItem) AS MenuItem " & _
                              "FROM " & sProgramsExclusion & " A " & _
                              "LEFT JOIN " & sPrograms & " B ON A.System=B.System AND " & _
                                                               "A.Program = B.Code " & _
                              "WHERE A.System='" & sSys_ & "' AND " & _
                                    "A.CompanyID='" & sCia_ & "' AND " & _
                                    "A.User='" & sU_ & "';"
 
 
  
        Dim sSQL_ As String = "SELECT Code,CONCAT(Name,SPACE(2),Description,SPACE(2),IF(TownAirport='T','Town','Airport')) AS 'Description'" & _
                              " FROM " & sTable_ & _
                              " WHERE CompanyID = '" & sCia_Code_ & "'" & _
                              " ORDER BY Name"
 
 
 
         Dim sSQL_ As String = "SELECT DISTINCT(VehicleObs) FROM " & sTable_ & _
                              " WHERE CompanyID = '" & sCia_Code_ & "'" & _
                              " ORDER BY VehicleObs"
 


        Dim sSQL_ As String = "SELECT HolderName FROM " & sTable_ & _
                              " WHERE CompanyID = '" & sCia_Code_ & "' AND " & _
                                     "Code = '" & sCustomer_ & "'" & _
                              " ORDER BY HolderName"



        Dim sSQL_ As String = "SELECT Code,CONCAT(Last,', ',Name) AS Customer FROM " & sTable_ & _
                              " WHERE CompanyID = '" & sCia_Code_ & "'" & _
                              " ORDER BY Last,Name"



        Dim sSQL_ As String = "SELECT Code,CONCAT('',FromTownAirport,' - ',ToTownAirport) AS Fare FROM " & sTable_ & _
                              " WHERE CompanyID = '" & sCia_Code_ & "' AND " & _
                                     "Vehicle = '" & sVehicle_ & "'" & _
                              " ORDER BY FromTownAirport,ToTownAirport



    
SELECT p.product_id, p.product_name, inventory.quantity
FROM products p
INNER JOIN inventory
ON p.product_id = inventory.product_id
ORDER BY p.product_name ASC, inventory.quantity DESC;


	

I think you are looking for the update statement. For example:

ALTER TABLE mn2012ct_geom2 ADD COLUMN obama_pct decimal(10,2);

update mn2012ct_geom2
    set obama_pct = CAST(obama AS DECIMAL) / CAST(uspres_total AS DECIMAL);

You might also consider just creating a view to do the calculation:

create view v_mn2012ct_geom2 as
    select g.*, CAST(obama AS DECIMAL) / CAST(uspres_total AS DECIMAL) as mn2012ct_geom2
    from mn2012ct_geom2;




# -  - #
# - To test - #

https://stackoverflow.com/questions/16253220/missing-row-from-self-inner-join-sql-query


https://stackoverflow.com/questions/7869592/how-to-do-an-update-join-in-postgresql

UPDATE vehicles_vehicle AS v 
SET price = s.price_per_vehicle
FROM shipments_shipment AS s
WHERE v.shipment_id = s.id