Subversion Repositories computer_asset_manager_v1

Rev

Rev 43 | Rev 46 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 43 Rev 45
Line 47... Line 47...
47 
   license join license_product using (license_product_id)
 47 
   license join license_product using (license_product_id)
48 
   left outer join device using (device_id)
 48 
   left outer join device using (device_id)
49 
   join client using ( client_id )
 49 
   join client using ( client_id )
50 
order by license_product.name, device.name;
 50 
order by license_product.name, device.name;
51
51
52 
delete from menu
- 
 
53 
where
- 
 
54 
   menu.parent_id in
- 
 
55 
      ( select menu_id
- 
 
56 
        from (
- 
 
57 
           select distinct a.menu_id as menu_id
- 
 
58 
           from menu a join menu b on a.menu_id = b.menu_id
- 
 
59 
           where a.caption = 'Licenses'
- 
 
60 
           )
- 
 
61 
      as c );
 -