Gary,
Something like this
SELECT DISTINCT a.CategoryName
FROM Table(A) a, Table(B) b
WHERE a.CategoryId = b.CategoryID
AND b.ItemID = 20
Sunday, September 10, 2000, 8:43:45 PM, you wrote:
Gary> I am having a problem pulling what I want from a couple of tables and any
Gary> help
That did it. Thanks, Gary
- Original Message -
From: "Tom Muck" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 10, 2000 10:50 AM
Subject: Re: Need Help With a Query
> Try SELECT DISTINCT a.CategoryName
> FROM Table(A) a, Tab
Try SELECT DISTINCT a.CategoryName
FROM Table(A) a, Table(B) b
WHERE a.CategoryId = b.CategoryID
AND b.ItemID = 20
tom
- Original Message -
From: "Gary J. Groomer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 10, 2000 1:43 PM
Subject: Need H
I am having a problem pulling what I want from a couple of tables and any
help would be greatly appreciated. Find below a simple synopsis of the two
tables.
Table(A)
-
CategoryName CategoryID
---
CategoryName11
CategoryName2
4 matches
Mail list logo