1 The best way to pull data from multiple database tables is to create a Database View where the tables are joined and than to use this view with Tools JX. What is a Database View (SQL View)? How to create a database View and use it with Tools JX?