Have just started playing with Therions sql outputs, and bumbling along. May have found a bug? Running the query select ID, SURVEY_ID, NAME, X, Y, Z, FLAG from STATION, STATION_FLAG group by SURVEY_ID, NAME; results in D SURVEY_ID NAME X Y Z FLAG 2 34 F100 2500604.74 6023114.36 620.49 fix 3 34 F101 2500601.9 6023115.01 618.94 fix 4 34 F102 2500599.78 6023118.02 620.73 fix 5 34 F103 2500604.18 6023127.05 622.96 fix 6 34 F104 2500613.11 6023143.64 625.37 fix etc. Problem is that ALL the 1200 station flags are fixed. Most should be null I think, there should be three entrance flags, and some continuation flags. At least that is what has been entered and what the 'caves' and 'continuations' outputs indicate. A bug, or am I misunderstanding something? Using 5.2.7 Bruce