Простой пример связи между парками, машинами, станциями
Среда MS-SQL
Code
SELECT TOP 1000 t.[NSIT_UniqueID]
,t.[Park_Identificator],p.PK_Short,NSIR_StationNum
,[NSIT_StateNumb]
,[NSIT_GaragNumb]
,[NSIT_SpecTitle]
,[NSIT_Class_B]
,[NSIT_Class_C]
,[NSIT_Group]
,[NSIT_Colonna]
FROM [SPECTRANS].[dbo].[tbNSITransport] as T
inner join [SPECTRANS].dbo.tbParks as p on p.PK_Identificator=t.[Park_Identificator]
inner join [SPECTRANS].dbo.tbRadioTransportLink as TL on tl.NSIT_UniqueID=t.[NSIT_UniqueID]
where [NSIT_Deleted]=0
order by NSIR_StationNum