ник: Explorer
я честно говоря не понял в чем проблема с этими запросами 
то, что аксес по своему их перелывает - так это да, он такой
SELECT "a" AS DD
FROM ((((document_type AS DT
INNER JOIN ((discipline AS DI
INNER JOIN document AS D
ON DI.discipline_id=D.discipline_id)
INNER JOIN document_language AS DL
ON D.document_language_id=DL.document_language_id)
ON DT.document_type_id=D.document_type_id)
INNER JOIN facility AS F
ON D.facility_id=F.facility_id)
INNER JOIN progress_phase AS PP
ON D.progress_phase_id=PP.progress_phase_id)
INNER JOIN revision AS R
ON D.revision_id=R.revision_id)
INNER JOIN revision_status AS RS
ON D.revision_status_id=RS.revision_status_id;
|
SELECT "b" AS BB
FROM revision AS R
INNER JOIN (revision_status AS RS
INNER JOIN (progress_phase AS PP
INNER JOIN (facility AS F
INNER JOIN (document_type AS DT
INNER JOIN (document_language AS DL
INNER JOIN (discipline AS DI
INNER JOIN document AS D
ON DI.discipline_id = D.discipline_id)
ON DL.document_language_id = D.document_language_id)
ON DT.document_type_id = D.document_type_id)
ON F.facility_id = D.facility_id)
ON PP.progress_phase_id = D.progress_phase_id)
ON RS.revision_status_id = D.revision_status_id)
ON R.revision_id = D.revision_id;
|