Subversion Repositories computer_asset_manager_v1

Rev

Rev 31 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 31 Rev 39
Line 1... Line 1...
1 
select
1 
select
2 
   count(*) tasks,
 2 
   count(*) tasks,
- 
 
 3 
   device.device_id deviceid,
3 
   device.name device,
 4 
   device.name device,
4 
   site.name site,
 5 
   site.name site,
5 
   client.name client,
 6 
   client.name client,
6 
   email tech
 7 
   email tech,
- 
 
 8 
   login_id techid
7 
from
 9 
from
8 
   maintenance_schedule join device using (device_id)
 10 
   maintenance_schedule join device using (device_id)
9 
   join site using (site_id)
 11 
   join site using (site_id)
10 
   join client using (client_id)
 12 
   join client using (client_id)
11 
   join login using (login_id)
 13 
   join login using (login_id)