There is no MIDDLE JOIN. As MIDDLE is not a keyword or predicate and there is no alias already specified for tblCustomers, MIDDLE is taken as the alias.
Your queries do not work as you have specified an alias for the table (AS c).
Ade
A Freudian Slip is when you say one thing and mean your mother. For detail-enriched answers, ask detail-enriched questions...[/url]