I am building an application, and now have a need to join a couple of tables, but have not figured it out yet. Here is a bit about the application setup:[list][*]Base

• config.ini
• application
  • controllers
    • AssetController.php
  • models
    • Asset.php
  • views
    • Scripts
      • asset
        • index.phtml
• public_html
  • index.php

My config contains all of my db connection info, and is retrieved using Zend_Config.
I have also setDefaultAdapter using Zend_Db_Table, and stored the info in the Zend_Registry as well.

• In my /models/Asset.php I simply have a class that provides the name of the asset table in the DB.
• In my /controllers/AssetController.php my method indexAction() needs to supply the data so that the view index.phtml can display a table of the results.

The problem I am having is that in order for me to pull complete hardware info I need to pull info from three tables. I am trying to grasp using Zend_Db_Select so that I can use JOIN in the queries, but I am totally lost.

I have found no samples of doing a JOIN, or perhaps I just don't understand it enough to see it.

Can anyone please help?