0 - 1 of 1 tags for join with substring

Hi - I fully understand that this is not the best way to organize data.  However, this is how the data already exists, and i want to run a query and coul duse some help!  I have field aa in TABLE AA, and if i take a substring of field aa it will match perfectly to field bb of TABLE BB.  and once matched, I get lots of wonderful information from TABLE BB.