select
	f.typeoftransaction,
	pa.typeoftransaction,
	f.Journalnumber,
	f.Yearoftransaction,
	f.Numberoftransaction,
	f.Numberrelation,
	f.Valuedate,
	f.Expirydate,
	f.subtypeoftransaction,
	f.transactamountforeigncurrency,
	f.balanceforeigncurrency,
	pa.transactamountforeigncurrency,
	pa.Yearoftransaction,
	pa.Numberoftransaction,
	pa.JournalNumber,
	pa.ValueDate,
	pa.ExpiryDate
	from
	accountingtransactionsdetail f
	LEFT JOIN accountingtransactionsdetail pa ON (
		pa.typeoftransaction = 4
		AND
		pa.JournalPayedDocument = f.JournalNumber
		AND
		pa.YearPayedDocument = f.YearOfTransaction
		AND
		pa.NumberPayedDocument = f.NumberOfTransaction
		AND
		pa.NumberRelation = f.NumberRelation
	)
	where f.typeoftransaction = 1
	and
	f.codeadvance <> 1
	and
	f.balanceforeigncurrency <> 0
	and f.numberrelation = 10217
	ORDER BY pa.numberrelation DESC