I have two tables that I need to left join but the records need to be manipulated first and I can't quite get it to work...
the following illustrates what I have better than I can explain it:
table1.custname left joined to table2.name
john smith smith, john
Alpha Beta bETa, AlPhA
because my query is a grouping query (or simply because i'm screwing it up somehow), I can't simply do the join in the criteria of the design view.
if someone can provide the sql on how to join them i'd appreciate it!
thanks for your help!