Re: [lms] pytanko o select mysql

2007/8/7, Wojciech Ziniewicz wojciech.ziniewicz@gmail.com:

Dla potomnych - ID klientów z przeterminowanymi umowami itd.. (sami klienci, nie poszczegolne komputery)

SELECT DISTINCT customers.id FROM customers, nodes WHERE customers.id = ownerid AND deleted = 0 AND access = 1 AND NOT EXISTS (SELECT 1 FROM assignments WHERE customerid = customers.id AND (datefrom <= UNIX_TIMESTAMP() OR datefrom = 0) AND (dateto >= UNIX_TIMESTAMP() OR dateto = 0) AND (tariffid != 0 OR liabilityid != 0) )