I was able to join 3 tables and count the data set, bet getting the columns on specific table it only see the 3rd table column..
FROM `InvoiceItemTable` a
JOIN `InvoiceTable` b
ON (b.id = a.invoice)
JOIN `products` c
ON (a.product = c.id)
WHERE b.status='1' AND c.store = '2'
//$invoices = $inginger->fetch(PDO::FETCH_ASSOC))
php wont recognize
$invoices['a.price']; you have to use
if you have same fieldname in multiple tables you have to create an alias
SELECT a.price as a_price, b.price as b_price, c.price as c_price
and then you can use