Hi Cindy

- I'm using all fields, except CGR_OUT from "record 1" and only CGR_OUT from "record 2".
- There are always two records.
- Only the field CODE will always be the same.


>>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?