Quering 2 IDs from a single table

From: Paul (hytmgrt_at_yahoo.com)
Date: 05/30/04 

Date: Sun, 30 May 2004 18:42:09 +0200

Hi,

I need to query 2 salesman_ID from a table but I cannot figure out how.

SELECT salesman_ID,

FROM product

WHERE salesman_ID=23 AND salesman_ID=18

and

SELECT A.salesman_ID

FROM product A

INNER JOIN product B ON A.product_ID = B.product_ID

        AND A.salesman_ID = 19

        AND B.salesman_ID = 23

Don't work.

What am I missing.

TIA

Paul

Relevant Pages

  • Re: Quering 2 IDs from a single table
    ... "Paul" wrote in message ... > INNER JOIN product B ON A.product_ID = B.product_ID> ... > What am I missing. ... > TIA ...
    (microsoft.public.access.queries)
  • Re: need help on select
    ... Would you put the results of the query I sent you. ... >> From Distribution d Inner Join Product p ...
    (microsoft.public.sqlserver.datamining)
  • Re: need help on select
    ... i do query with text results and paste for better understanding ... inner join product on distribution.pro_cod = product.pro_cod ... >> i try the subquery but it returns much rows so results of the sum are ...
    (microsoft.public.sqlserver.datamining)