Display required records from same table

hemantkumarniec · #1 (**permalink**) 05-15-09, 09:40

Hi all,

I get stuck in a query . My table as:

local foreign
1 1
2 1
5 7
4 6
3 2
1 6
6 8
3 8

I want to find those "local" records which are in "foreign" column [(1 or 2) and (7) and (6)].

Please help me to solve this query.

Thanks in advance.

Hemant Kumar Upadhyay
FiveE Technology , New Delhi

galih · #2 (**permalink**) 05-23-09, 00:38

SELECT local FROM table_name
WHERE local=foreign

Unique?

SELECT DISTINCT local FROM table_name
WHERE local=foreign

r937 · #3 (**permalink**) 05-23-09, 01:09

Code:

SELECT DISTINCT
       one.local
  FROM daTable AS one
INNER
  JOIN daTable AS two
    ON two.foreign = one.local

Internet Services

Web Development

Digital Marketing

Consumer Tech