1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
|
SELECT hd.id, hd.name, hd.lastcome, a.tag, ht.hw_cpuz, ht.hw_gfxz, ht.hw_extz, ht.hw_locz, ht.hw_batz, ht.hw_pchz, ht.hw_tz0, ht.hw_others
FROM hardtemp ht join hardware hd on (ht.HARDWARE_ID = hd.ID) join accountinfo a on (hd.ID = a.HARDWARE_ID)
WHERE ht.hw_cpuz not in ("NC","")
or ht.hw_gfxz not in ("NC","")
or ht.hw_extz not in ("NC","")
or ht.hw_locz not in ("NC","")
or ht.hw_batz not in ("NC","")
or ht.hw_pchz not in ("NC","")
or ht.hw_tz0 not in ("NC","")
or ht.hw_others not in ("NC","")
GROUP BY ht.hardware_id |
Partager