Witam c.addres to chyba pole string
UPDATE netdevices nd SET location =
(SELECT c.address from customers c, nodes n WHERE nd.id = n.netdev AND c.id = n.ownerid and c.address not like ''
LIMIT 1)
lub
UPDATE netdevices nd SET location =
(SELECT c.address from customers c, nodes n WHERE nd.id = n.netdev AND c.id = n.ownerid and c.address not like ' '
LIMIT 1)
On 15.09.2015 13:30, Marcin wrote:
UPDATE netdevices nd SET location =
(SELECT c.address from customers c, nodes n WHERE nd.id = n.netdev
AND c.id =
n.ownerid and c.address IS NOT NULL LIMIT 1)