Code Name NW London
1 Bill ---- ----
I need to update Users.NW = 1 in the Users Table. There are other cities like NW, London, Paris etc. In respective cities i need to update 1 and rest should be 0.
So, expected output
1 Bill 1 0
2 Steve 0 1
I hope i am clear to you. Thanks in advanced. This query is not working:
UPDATE Users SET NW='1' WHERE
(SELECT Users.Code, Contacts.code FROM Contacts
LEFT JOIN ON Users.code = Contacts.code AND
INNER JOIN ON Contacts.Country = Location.Country
) AND Users.NW = Location.City;
If you're in one of those predicaments where cls.__private attributes just aren't enough since they can easily be accessed through inst._cls__private, and you need something a little more secure, here's ...