Re: select query assistance

On Thu, 7 Apr 2005 08:05:04 -0700, AshleyT wrote:

>Perfect! Thanks.
>
>What about if I want only tickets where all ITEMS has Department 2. So they
>only bought Cigarettes.

Hi Ashley,

SELECT (column list goes here)
FROM YourTable AS a
WHERE NOT EXISTS (SELECT *
FROM YourTable AS b
WHERE b.Ticket_Num = a.Ticket_Num
AND b.Ticket_Date = a.Ticket_Date
AND b.Item_Dept <> 2)
(untested)

Also possible - maybe even faster:

SELECT Ticket_Num, Ticket_Date
FROM YourTable
GROUP BY Ticket_Num, Ticket_Date
HAVING MIN(Item_Dept) = 2
AND MAX(Item_Dept) = 2
(also untested)

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
.