inner join some problem is coming

Question

0.00/5 (No votes)

See more:

Table:
Model No int
Description varchar
Price int

now i want to show the models that have same price...I have tried with this

SQL

Copy Code

select distinct(Objpc1.Model),Objpc.Model  from pc Objpc1 , Pc Objpc
where Objpc.Price=Objpc1.Price and Objpc.Model!=Objpc1.Model

The output iam getting is

VB

Copy Code

1232    1233
1233    1232

but i need to show either of this as 1233 and 1232 or 1232 and 1233????

Posted 27-Jun-12 0:33am

dharan1990

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kamalkant(kk) · Answer 1 · 2012-06-27T00:44:00

Solution 1

SQL

Copy Code

select Objpc1.Model,Objpc.Model  from pc Objpc1 INNER JOIN Pc Objpc
ON Objpc.Price=Objpc1.Price

Permalink

Posted 27-Jun-12 0:44am

Kamalkant(kk)

Comments

dharan1990 27-Jun-12 6:48am

hi thanks for ur reply ...this will also produce the same result ...

Kamalkant(kk) 27-Jun-12 6:59am

YOUR TABLE IS ONE I.E PC

dharan1990 · Answer 2 · 2012-06-27T00:58:00

Solution 2

SQL

Copy Code

select distinct(Objpc1.Model),Objpc.Model  from pc Objpc1 , Pc Objpc
where Objpc.Price=Objpc1.Price and Objpc.Model!=Objpc1.Model and Objpc.model<Objpc1.model

Permalink

Posted 27-Jun-12 0:58am

dharan1990

inner join some problem is coming

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

inner join some problem is coming

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us