How to compare column value of two row of same table

[Atul Kumar]

comapre column value of two row of same table. suppose in table tabl1 have column name comn1 it has two row means two value... after comparison i have to return some value like true or false.......... .........

So tell me any in-built function is there in MS-sql............ .....

[r035198x]

comapre column value of two row of same table. suppose in table tabl1 have column name comn1 it has two row means two value... after comparison i have to return some value like true or false.......... .........

So tell me any in-built function is there in MS-sql............ .....

I havebeen re-reading your post again and again. Let me try to describe your problem again. You have one table with two rows. The table has a column called, say, comn1. And you want a query that returns true if the two rows have the same value in comn1?

[vanroojdotcom]

I think I understand what you mean.

you have one table and three fields - let's say

1) MAKE OF CAR (Page Heading)
2) COLOUR OF CAR (The make's description)
3) THIS MAKE IS OWNED BY (a dynamic link back to a parent company)

So a few entries may be
A - 1) Jaguar 2) Green 3) Ford
B - 1) Peugeot 2) Grey 3) Citroen-Peugeot
C - 1) Ford 2) Brown 3) NULL (Ford owns Ford) so it's blank

What you want is to match WHERE (3) = (1) but not in the same row (they never will and no matter what you do there is never a return). What you want is for the query to match over different rows ONLY so the database looks and sees that Field (3) = Field (1) in ROW A and returns the URL value Ford (which you can then use as a value to link to the Company "FORD" on page C. www.cars.com/cars.php?make=f ord

Is that correct?

[mark roles]

This was never answered, but I would like to know how, as in the example with the “CAR” example shown above.

[mark roles]

Here is what I came with to solve this senario:

+--------------------+
| tblName |
+--------------------+
+------+------+------+
| ID | C1 | C2 |
|------|------|------|
|------|------|------|
| 1 | a | x |
|------|------|------|
| 2 | b | c |
|------|------|------|
| 3 | c | f |
|------|------|------|
| 4 | d | z |
|------|------|------|
| 5 | e | q |
|------|------|------|
| 6 | f | a |
+------+------+------+

SO QUERY RESULTS WOULD BE = ID 1 & 6, ID 3 & 2, ID 6 & 3.




select a.ID, b.ID
from tblName a
join tblName b
on a.c1 = b.c2;

+------+------+
| id | id |
+------+------+
| 3 | 2 |
| 6 | 3 |
| 1 | 6 |
+------+------+