Hi Our Treker,
Data blending does have some limitations, so I generally recommend using a table join (or a cross database join if the tables are from different databases). See Join Your Data
If you are hitting a specific issue, then we may be able to provide more help if you can describe that specific issue. Especially with something like data blending if you can provide a workbook that is always hugely helpful.
Hope this helps