Query dilemma

[famousoren]

Hello!<br>I am trying to write an SQL statement that looks at an individual 'request' and then checks the audit trail to see if the issue has been reopened.&nbsp;&nbsp;If the issue has been reopened, assign the issue a &quot;1&quot;, else assign it a &quot;0&quot;<br>the final table would look like this.&nbsp;&nbsp;There is a separate request table and a separate audit table with multiple audit codes<br><br>requestid : timecreated : audit(reopen)<br><br>2006&nbsp;&nbsp;&nbsp;01/01/00&nbsp;&nbsp;&nbsp;1<br>2007&nbsp;&nbsp;&nbsp;04/07/00&nbsp;&nbsp;&nbsp;0<br><br>Thanks,<br><br>Oren<br>

 

[MikeLacey]

Oren,<br><br>Do you have the requestid column in the audit trail? <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>

 

[famousoren]

No, the requestid is in the

 

[MalcolmW]

The suspense is killing me