Query To Get The Data

[bharani1983]

How Can We Get The Data From A Single Table , By Comparing The Two Different Fields, Considering One Field Value From Row One And The Other Field Value From Row Two Having The Same Values???????

[RuralGuy]

Have you tried playing in the Query Builder for a while?

[bharani1983]

Have you tried playing in the Query Builder for a while?

No ....How abt u??Do u hav the solution for this ???

[NeoPa]

I think you need to explain your question better.

If this is about linking between different records in a table then we would need to know at least what you want to achieve.

[bharani1983]

I think you need to explain your question better.

If this is about linking between different records in a table then we would need to know at least what you want to achieve.

Below is the eg :table with data.Here NAME,ID,DNIS,CLI are the field name.

NAME         ID          DNIS       CLI
BHARANI          1    33333333     22222             row1
KAMAL         2       22222     44444             row2
FAIZAL        3       11111111     55555             row3
MANI          4       55555     66666             row4

What is the query to get the result as CLI of row1 = DNIS of row2.

[Ruth2B]

SELECT CsvTable.*
FROM CsvTable 
INNER JOIN CsvTable AS CsvTable_1 
ON CsvTable.CLI = CsvTable_1.DNIS;

[NeoPa]

Below is the eg :table with data.Here NAME,ID,DNIS,CLI are the field name.

NAME         ID          DNIS       CLI
BHARANI          1    33333333     22222             row1
KAMAL         2       22222     44444             row2
FAIZAL        3       11111111     55555             row3
MANI          4       55555     66666             row4

What is the query to get the result as CLI of row1 = DNIS of row2.

A query cannot be that specific - hence I asked you to explain your requirement more clearly.

Under which circumstance do you want to link the records?

Is it any match? Is it all matches? Are they to be grouped and aggregated?

We can't answer your question until you actually ask it.

PS. Having said that of course, Ruth2B's post illustrates the basics of how you'd access the data generally. You would also have access there to select fields from csvTable_1.