Ad:

MS SQL Discussion Thread
Unsolved
Views: 573

Jul 16th, 2009

Question about SELECT statement

Expand Post »

I have one table in this format:

Product  Component
---------------------------
A            part1
A            part2
B            part1
B            part4
A            part3
C            part5
D            part1

now I want to display product which components meet requested items, for example:
I know component are "part1" and "part3", need to show product name (that is "A").
How can I do that in SQL statement?

Thanks.

Similar Threads

Question about SELECT statement in MS SQL
Question about select statement in MySQL
Question about SELECT statement in MySQL
Question about SELECT statement. in MySQL
Getting current value in Select Statement in MS SQL

michael123

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

93 posts
since Jun 2005

Permalink

Jul 16th, 2009

Re: Question about SELECT statement

SQL Syntax (Toggle Plain Text)
SELECT Product FROM Table
WHERE Component IN ('part1','part3')
Select Product From Table
Where Component in ('part1','part3')

Last edited by cgyrob; Jul 16th, 2009 at 6:53 pm.

cgyrob

Reputation Points: 91

Solved Threads: 18

Junior Poster

Offline

125 posts
since Sep 2008

Permalink

Jul 16th, 2009

Re: Question about SELECT statement

How about "part1", "part3" are retrieved from SELECT statement? to use "select from table where component in (select part1 from....)"?
Also "IN(part1, part3)" is OR , not AND, right? I need "AND".

michael123

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

93 posts
since Jun 2005

Permalink

Jul 16th, 2009

Re: Question about SELECT statement

cgyrob's response was what you asked for. What is your real goal here? Or are we not understanding your problem correctly?

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

Permalink

Jul 17th, 2009

Re: Question about SELECT statement

If you really want an 'AND' use an 'AND'

SQL Syntax (Toggle Plain Text)
SELECT Product FROM Table
WHERE Component = 'part1'
AND Component ='part3'
Select Product From Table
Where Component = 'part1'
and Component ='part3'

cgyrob

Reputation Points: 91

Solved Threads: 18

Junior Poster

Offline

125 posts
since Sep 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: How to open Master Database File(.mdf)

Next Thread in MS SQL Forum Timeline: Aspx page wont search a database

DaniWeb Message

Cancel Changes

User Name
Password