Can a query reference another query or table?

Hello, I have a query & one table that cannot be joined because the account number format in the query is ex. 123456 & the table 021000123456. I've tried

Formula:

 Like "*" & [Query]![Field] 

but it doesn't work... I've attempted to format the data in query one so it can match the format in the table but that didn't go anywhere...