>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.
>
>How do I do this ????????

Benn--

A self join should do the trick. A typical example of this is an employee database and one queries to find someone's boss. Note that the same table is used with 2 aliases, A and B.

SELECT A.CGR_IN, B.CRG_Out ;
   FROM MyTable A, MyTable B ;
   WHERE A.Code = B.Code

Jay