| 0,0 → 1,21 |
|---|
| <head> |
| <meta http-equiv="Content-Type" content="text/html"; charset="iso-8859-1"> |
| <meta name="keywords" content="CS2REP"> |
| <meta name="author" content="CHARONWARE - www.casestudio.com"> |
| <title>CASE Studio 2 - HTML Report</title> |
| <link rel="stylesheet" type="text/css" media="screen" href="simple_blue.css" title="report"> |
| </head> |
| |
| <body bgcolor="#FFFFFF" leftmargin="20" topmargin="10" marginwidth="20" marginheight="10"> |
| <a name = "View_1"></a> |
| <table border="0" width="100%" class="caption1"><tr><td>allocmi</td></tr></table><br><br> |
| <table class="tabformat" border="0" cellpadding="2" cellspacing="1" width="100%"> |
| |
| <tr> |
| <td class="tabdata" > <pre><code>// created on 14.10.2004 13:56:56<br> <br> create view allocmi as<br> select allocation.al_num as am_num,<br> allocation.al_task as am_task,<br> allocation.al_ressource as am_ressource,<br> allocation.al_hours as am_hours,<br> allocation.al_phase as am_phase,<br> key_role.kr_role as am_role,<br> key_role.kr_num as am_krnum,<br> mitarbeiter.mi_vname as am_vname,<br> mitarbeiter.mi_nname as am_nname,<br> allocation.al_pstart as am_pstart,<br> allocation.al_pduration as am_pduration<br> from allocation, mitarbeiter, key_role<br> where mitarbeiter.mi_num = allocation.al_ressource<br> and key_role.kr_num = allocation.al_role; |
| </code></pre> </td> </tr> |
| </table> |
| |
| <br><br> |
| </body><br><br> |
| |