Doubt with display a query using Custom Field Module in View
You can set up relationships in views to pull data from other tables should you have to.  There's a screencast from Drewish here on how they work and how to set them up.

Basically, you'd need to set up a relationship based on a part of the current data in the row.  After this, more data is exposed to you in the fields section of views.

If I'm misunderstanding your question and you'd just like to embed a view withing a view, then check our the Views Field View module.


  This module allows you to embed a view as a field in a view.
  
  This view can accept arguments from fields of the parent view using
  tokens.