find differences between two mysql_query results. HELP

When I type an agentnum and hit submit at will look up that agentnum
and tell you what skill set (msp_sk,ste_sk,wash_sk,ectect) they are not
a part of.

For Example
the first statement I have been ussing is this. it Tells me what they
DO have.
SELECT queue FROM agentqueue_table WHERE agentnum='12345' GROUP BY
queue;
The result is
+-----------+
| queue |
+-----------+
| msp_sk |
| ste_sk |
+------------+

The second statment is, it tells me what all the skill sets are.
SELECT queue FROM agentqueue_table GROUP BY queue;
+-------------+
| queue |
+-------------+
| msp_sk |
| ste_sk |
| wash_sk |
+-------------+

I want to compare the two results and know the difference is wash_sk

I need to do this dynamicly as well. Lets say I do another agentnum
lookup with agent 54321 and his results are as followed
+-----------+
| queue |
+-----------+
| msp_sk |
| wash_sk |
+------------+
and compare it to again,
SELECT queue FROM agentqueue_table GROUP BY queue;
+-------------+
| queue |
+-------------+
| msp_sk |
| ste_sk |
| wash_sk |
+-------------+
The answer I want to get then is ste_sk

If I am going about this all wrong please let me know!
I have spent all day trying to find a way to do this and i can't! I am
going nuts... Please help!

.

Relevant Pages

  • Re: find differences between two mysql_query results. HELP
    ... and tell you what skill set they are not ... the first statement I have been ussing is this. ... SELECT queue FROM agentqueue_table WHERE agentnum='12345' GROUP BY ... If you want all different rows in agentqueue_table that a certain agentnum ...
    (php.general)
  • Re: Quene display
    ... > This function is used to display the context of a queue. ... > integer comparing with the queue cuisine number, ... This attempts to compare a pointer with a character. ...
    (comp.lang.cpp)
  • Re: input problem
    ... > If my input is an integer, how can I compare w/ the queue ... > in order to display the context containing the ...
    (comp.lang.cpp)
  • Re: RCU+SMR
    ... single-reader FIFO message queue. ... An implementation of a message- passing concurrent language uses this kind of queue for all communication between processes, and would benefit from an implementation with very low overhead on multiprocessors. ... The single reader just grabbed the entire queue using compare and swap, reversed order making it FIFO and worked off of that util it was empty and then repeated the whole process by grabbing the shared LIFO stack again. ...
    (comp.programming.threads)
  • Re: input problem
    ... > If my input is an integer, how can I compare w/ the queue ... > in order to display the context containing the ...
    (comp.lang.c)