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