>I am trying to produce a list of records from one table. The records have a number associated with them and a description. In addition to this they have a type which is either Sample or Technical. For example:
>
>0001 Car Sample
>0002 Boat Sample
>0003 Caravan Sample
>0004 Lorry Sample
>0005 Train Sample
>0001 Car Technical
>0002 Boat Technical
>0003 Caravan Technical
>
>I want to list (SQL) those records where there is a sample and an eqivalent technical type. So taking the above into account if I run the query I will get the following:
>
>0001 Car Sample
>0002 Boat Sample
>0003 Caravan Sample
>0001 Car Technical
>0002 Boat Technical
>0003 Caravan Technical
>
>This will give me a list of results where the sample records have equivalent technical records.
>
>Many Thanks
SELECT * from MyTable
WHERE keys in
(select keys from test WHERE "Technical" = type)
Edgar L. Bolton, B.S. B.B.A.