JOIN condition limited to immediate previous table
when suggesting the final join conditions for the following
join tableB on tableA.Aid = tableB.Aid
join tableC on tableB.Bid = tableC.Bid
join tableD on .......
SQL Prompt tries only to find matches between tableD and tableC, although in this case there is a link between tableA and tableD (infact there is even a FK relationship between the two)