$shop->addSqlAssociation('Product', 'Product_FK', 'LEFT JOIN', 'product_id', array('sku', 'name', 'price'));
$shop->addSqlAssociation('Order', 'Order_FK', 'LEFT JOIN', 'order_id', array('customer_id', 'total_price'));In this example, the shop will associate the "Order" table with the "Order_FK" foreign key via a left join SQL statement. The column map specifies that the customer ID should be associated with the "customer_id" and the total price should be associated with the "total_price". Package library: Zend_Db_Table_Abstract.