>Hi, can anyone help me with an SQL query.
>
>My records looks like this:
>

CGR_IN  CGR_OUT DEST ORIGIN TC ANO BNO CODE
noco120         UK   T1-SO3 10 123 456 AB02
        noco165 UK   T1-SO3 20 123 456 AB02

>
>I need an SQL query that combines informations from both records with CODE as the keyfield.

Which fields do you want to combine? are there always only two records? How many fields in the two records will be the same?