una query complicata! qualcuno mi aiuta?

[badaze]

E cosi ?

select * from vm_product L1, vm_product_price L2A, 
vm_product_mf_xref L2B, vm_product_category_xref L2C,
vm_manufacturer L3A, vm_category L3B
where L1.product_id  = L2A.product_id  and
      L1.product_id  = L2B.product_id  and
      L1.product_id  = L2C.product_id  and
      L2B.manufacturer_id = L3A.manufacturer_id and
      L2C.category_id     = L3B.category_id