<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: MySQL and RT2 - URGENT!!!</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2 FACE="Arial">Hello,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I am trying to run a report that will give the total number of tickets in a given queue that are 'stalled' and that have a specific keyword assigned to them.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">I have the following two queries</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">SELECT COUNT(*) FROM ObjectKeywords WHERE Keyword='18';</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">and,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">SELECT COUNT(*) FROM Tickets WHERE Queue='16' AND Status='Stalled';</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">My task is to combine these two queries so that the result is that I can count the number of Tickets in Queue='16' which are Stalled and have the Keyword='18' assigned to them. </FONT></P>
<P><FONT SIZE=2 FACE="Arial">Any help will be greatly appreciated.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Thank you</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Henry</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2 FACE="Arial"> "The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all computers." </FONT></P>
<BR>
</BODY>
</HTML>