10 Mar
2018
10 Mar
'18
17:54
Podpowiedzcie proszę ja z bazy wyciąnąc oprócz n/w jeszcze Nazwa komputera, IP, MAC
przydało by się: Klient, Informacja o połączeniu sieciowym
select lastname, c.name, address, zip, city, email, c.id, pin, count(n.id), n.name, passwd, cc.invoice, ccc.phone, cccc.customergroupid FROM customers c LEFT JOIN nodes n ON n.ownerid = c.id LEFT OUTER JOIN assignments AS cc ON cc.customerid = c.id LEFT OUTER JOIN customercontacts AS ccc ON ccc.customerid = c.id LEFT OUTER JOIN customerassignments AS cccc ON cccc.customerid = c.id
WHERE deleted=0 GROUP BY c.id
Pozdrawiam *DeCha*