select query assistance
- From: "AshleyT" <AshleyT@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 5 Apr 2005 12:31:10 -0700
Querying a table that has the line items for a ticket sold at a retail store.
So I am looking for the tickets that only have CIGARETTE items on it. The
ITEM table has columns:
TICKET NUM (PK)
TICKET_DATE (PK)
LINE # (PK)
ITEMDESC
ITEM UPC
ITEM DEPARTMENT (When equal to 2 then cigarette)
So I want tickets that ONLY have cigarette items (all items on the tickets
are cigarettes no matter the ITEM count.)
Thanks for any help.
.
- Follow-Ups:
- Re: select query assistance
- From: Hugo Kornelis
- Re: select query assistance
- Prev by Date: Re: Query Help with IF stmt
- Next by Date: Re: select query assistance
- Previous by thread: Use Results From a Select as the "From" for Another Select
- Next by thread: Re: select query assistance
- Index(es):