xPDO innerJoin

<?php
	$path = MODX_CORE_PATH . 'components/ocLatestProducts/';
	$result = $modx->addPackage('ocLatestProducts',$path . 'model/','opcart_');
	if (! $result) {
	  return 'failed to add package';
	}
	
	$query = $modx->newQuery('Product');
	$query->innerJoin('ProductDescription', 'PD');
	$query->select(array (
	    'Product.*',
	    'PD.name'
	));
	$query->where(array (
	    'Product.product_id' => 'PD.product_id',  
	));
	$query->sortby('date_added', 'DESC');
	$query->limit(6);
	
	$products = $modx->getCollection('Product',$query); 

	$output = '<p>Total: '. count($products) . '</p>';

	foreach($products as $product) {

	    $output .= '<p>Name: ' . $product->get('name');
	    $output .= '<p>Price: ' . $product->get('price');
	    $output .= '<br />Image: ' . $product->get('image') . '<br /></p>';
	}

	return $output;

SELECT Product.*, PD.name FROM `opcart_product` AS `Product` JOIN `opcart_product_description` `PD` ON WHERE `Product`.`product_id` = 0 ORDER BY date_added DESC LIMIT 6

$query->innerJoin('ProductDescription', 'PD',array('Product.product_id' =>'PD.product_id'));

SELECT Product.*, PD.name FROM `opcart_product` AS `Product` JOIN `opcart_product_description` `PD` ON `Product`.`product_id` = 0 ORDER BY date_added DESC LIMIT 6

$query->innerJoin('ProductDescription', 'PD', array("Product.product_id = PD.product_id"));

<?php
	$products = $modx->getCollection('Product',$query); 

	$output = '<p>Total: '. count($products) . '</p>';

	foreach($products as $product) {

	    $output .= '<p>Name: ' . $product->get('name');
	    $output .= '<p>Price: ' . $product->get('price');
	    $output .= '<br />Image: ' . $product->get('image') . '<br /></p>';
	}

	return $output;

<?php
$output .= '<pre>' . print_r($product->toArray(),true);

Array
(
    [product_id] => 43
    [model] => Product 16
    [sku] => 
    [location] => 
    [quantity] => 9
    [stock_status_id] => 5
    [image] => data/macbook_1.jpg
    [manufacturer_id] => 8
    [shipping] => 0
    [price] => 500
    [tax_class_id] => 9
    [date_available] => 2009-02-03
    [weight] => 0
    [weight_class_id] => 1
    [length] => 0
    [width] => 0
    [height] => 0
    [length_class_id] => 2
    [status] => 1
    [date_added] => 2009-02-03 21:07:49
    [date_modified] => 2010-03-25 14:37:30
    [viewed] => 0
    [sort_order] => 0
    [subtract] => 1
    [minimum] => 1
    [cost] => 0
)

Array
SELECT `Product`.`product_id` AS `Product_product_id`, `Product`.`model` AS `Product_model`, `Product`.`sku` AS `Product_sku`, `Product`.`location` AS `Product_location`, `Product`.`quantity` AS `Product_quantity`, `Product`.`stock_status_id` AS `Product_stock_status_id`, `Product`.`image` AS `Product_image`, `Product`.`manufacturer_id` AS `Product_manufacturer_id`, `Product`.`shipping` AS `Product_shipping`, `Product`.`price` AS `Product_price`, `Product`.`tax_class_id` AS `Product_tax_class_id`, `Product`.`date_available` AS `Product_date_available`, `Product`.`weight` AS `Product_weight`, `Product`.`weight_class_id` AS `Product_weight_class_id`, `Product`.`length` AS `Product_length`, `Product`.`width` AS `Product_width`, `Product`.`height` AS `Product_height`, `Product`.`length_class_id` AS `Product_length_class_id`, `Product`.`status` AS `Product_status`, `Product`.`date_added` AS `Product_date_added`, `Product`.`date_modified` AS `Product_date_modified`, `Product`.`viewed` AS `Product_viewed`, `Product`.`sort_order` AS `Product_sort_order`, `Product`.`subtract` AS `Product_subtract`, `Product`.`minimum` AS `Product_minimum`, `Product`.`cost` AS `Product_cost` FROM `opcart_product` AS `Product` JOIN `opcart_product_description` `PD` ON Product.product_id = PD.product_id ORDER BY Product.date_added 

SELECT * 
FROM ah_user_attributes 
INNER JOIN ah_member_groups 
ON ah_user_attributes.internalkey=ah_member_groups.member

$query = $modx->newQuery('modUserProfile');
$query->innerJoin('modUserGroupMember','Group', array("modUserProfile.internalKey = modUserGroupMember.member"));
$user_table_info = $modx->getCollection('modUserProfile',$query);

foreach ($user_table_info as $ah_user) {

    $ah_user_ext = $ah_user->get('extended');
    $output .= '<tr>
                   <td>'.$ah_user->get('fullname').'</td>    
                   <td>'.$ah_user_ext['institution'].'</td>  
                   <td>'.$ah_user_ext['degree'].'</td>
                   <td>'.$ah_user_ext['field_of_study'].'</td>
                   <td>'.$ah_user_ext['major'].'</td>
                   <td>'.$ah_user_ext['year_of_study'].'</td>
                   <td>'.$ah_user->get('gender').'</td>
            </tr>';
  }
  return $output;