I have a Query, I would like to lookup a column to a table in another report.

Now for tables, it is easy enough you just select Edit > Lookups and then Join the two tables. Problem is I need the query's column to be the "Column from current table" and I need the Table I am looking up to, to be the "Column to Lookup"

Can this be achieved, or will I need to rewrite it all to achieve a join function?