It doesn't allow me to join from my subquery to the main table when the subquery is in the from clause.