sql - How do I do an inner join while also joining using the where clause? -

select products.sku, products.mpn, products.manufacturer, dpi.dlrcost, dpi.msrp, dpi.quantity, pu.unitofmeasure, pu.actualweight, pu.shipweight,     pu.length, pu.width, pu.height (select partnumber sku, mpn, manufacturer activeproducts union select sku, mfp, brand  activeitems union select sku, mfr_part_number, manufacturer allproductscombined ) products, dealerpriceinventory dpi, priceupdate pu products.sku=dpi.sku , dpi.sku=pu.sku 

i want left join results above query table because not skus in right table. there anyway accomplish without inner joining tables in statement?

"new" ansii syntax has been introduced in 1992 free use in query.

...from (...) products     left join dealerpriceinventory dpi on products.sku=dpi.sku     left join priceupdate pu on dpi.sku=pu.sku  <some other conditions>