Profound Logic Forums

So im trying to join two tables to use a series of parameters to narrow down a search. I want to use those results to populate either an auto-complete text box or a drop down menu. What would be the best way to set up a join on two tables WITHOUT creating a logical view of those two tables?

It seems the answer is found here: http://www.profoundlogic.com/forum/view ... =53&t=2356