Selecting values from multiple tables

[Gurcharan]

Hello,

I need to access data from multiple table and to display it in FTL template.
What API is available which enable selecting values from multiple tables
based on a condition.

For Example - I need to select descriptions of all products which belongs to
a particular supplier.

Gurcharan