Select statment

[Amarni]

i want to make an select statment like that select * from Table_name Where ID=2 and ID=4 and ID=5 while the Id in not the primery key amarni

[Colin Angus Mackay]

Amarni wrote:

select * from Table_name Where ID=2 and ID=4 and ID=5 while the Id in not the primery key

I don't understand what you are trying do do here. Perhaps if you explained without trying to write in Pseudo-SQL it would be more helpful As far as I can tell you want All columns from rows where the Id column is equal to 2, 4 and 5 all at the same time. I really don't undersrtand what you mean by "the Id in not the Primary Key". The Id column is either the primary key or it isn't and that will apply to all rows in the table.

---

Scottish Developers events: * .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog

[Amarni]

sorry it is not primery key but i need this imagine that i have three table x has X_ID(Primery) and Name,..... atrribute y has Y_ID(Primery) and desc,..... atrribute the relation between them is many to many so that i creat a table between them named xy that conatain both IDs X_ID and y_ID so that i want to make select statment like that select * from x Where Y_ID=2 and Y_ID=4 and Y_ID=5 i hope you understatnd it now Amarni

[Subramaniam s V]

Could you please post exactly what you want to arrive ?

[Paddy Boyd]

I think you just want a join like this:

SELECT DISTINCT x.*
FROM x
INNER JOIN xy
ON x.x_id = xy.x_id
WHERE xy.y_id in (2,4,5)