4 Cze
2012
4 Cze
'12
21:42
2012/6/4 Szymon Kajewski lysysoft@o2.pl
W dniu 2012-06-04 21:06, Szymon Kajewski pisze:
SELECT sum(`cash`.`value`) FROM cash , macs, nodes where `macs`.`nodeid`
= `nodes`.`id` AND `nodes`.`ownerid` = `cash`.`customerid` and `macs`.`mac` = '00:04:23:1a:74:58'
A ładniej : SELECT sum(cash.`value`) FROM macs INNER JOIN nodes ON macs.nodeid = nodes.id INNER JOIN cash ON nodes.ownerid = cash.customerid WHERE macs.mac =UPPER('00:04:23:1A:74:58')
Dzieeeeki! Działa jak trzeba :D