SELECT [ALL | DISTINCT] [TOP nExpr [PERCENT]] Select_List_Item [, ...]
   FROM [FORCE] Table_List_Item [, ...]
      [[JoinType] JOIN DatabaseName!]Table [[AS] Local_Alias]
      [ON JoinCondition [AND | OR [JoinCondition | FilterCondition] ...] 
   [WITH (BUFFERING = lExpr)]
   [WHERE JoinCondition | FilterCondition [AND | OR JoinCondition | FilterCondition] ...]
   [GROUP BY Column_List_Item [, ...]] [HAVING FilterCondition [AND | OR ...]]
   [UNION [ALL] SELECTCommand]
   [ORDER BY Order_Item [ASC | DESC] [, ...]]
   [INTO StorageDestination | TO DisplayDestination]
   [PREFERENCE PreferenceName] [NOCONSOLE] [PLAIN] [NOWAIT]

CLOSE ALL
CLOSE DATABASES
OPEN DATABASE (HOME( 2 ) + 'Data\TestData')
SELECT DISTINCT TAlias1.company, TAlias2.order_date, ;
   TAlias2.shipped_on ;
   FROM customer TAlias1, orders TAlias2 ;
   WHERE TAlias1.cust_id = TAlias2.cust_id

Spr_Fam(
id_fam,; && поле уникальности
First_f,; && фамилия
Second_f,; && Имя
Third_f,;  && Отчество
...)

Q_info(
id_inf,; && поле уникальности, если нужно
id_fam,;  && поле связи с таблицей Spr_Fam
data_doc,;  && дата документа
 ....)

SELECT DIST F.First_f, F.Second_f, F.Third_f ;
   FROM Spr_Fam F INNER JOIN Q_info Q ;
   ON F.Id_fam = Q.Id_fam ORDER BY  1 , 2 , 3  ;
   INTO CURSOR Q_uniq_fam

SELECT DIST Q.data_doc, F.First_f, F.Second_f, F.Third_f ;
   FROM Spr_Fam F INNER JOIN Q_info Q ;
   ON F.Id_fam = Q.Id_fam ORDER BY  1 , 2 , 3 , 4  ;
   INTO CURSOR Q_uniq_fam