SELECT *; FROM mytable; WHERE id + Type IN ; (SELECT id + IIF(Type = "Sample", "Technical", type) FROM mytable)>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>
>0001 Car Sample >0002 Boat Sample >0003 Caravan Sample >0001 Car Technical >0002 Boat Technical >0003 Caravan Technical>