Go to most recent revision | Blame | Last modification | View Log | RSS feed
<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>