i have sql query in trying fetch items along components have bill of materials (bom) enabled , creation date withing last 3 years. problem every item along component list gets repeated. suppose item has 5 components, , query particular item number. 35 rows (7 repetitions of sets of 5 components). however, if query particular wip_entity_name or if use distinct, perfect 5 rows of data. need data (5 rows, no repetitions) when query particular item number. here query: select * bom_bill_of_materials bom, bom_inventory_components bic, bom_components_b bcb, bom_operational_routings_v borv, bom_operation_sequences_v bosv, bom_structures_b bsb, bom_structure_types_b bst, mtl_system_items_b msi, mtl_system_items_tl msit, org_organization_definitions ood, wip_discrete_jobs_v wdjv bom.bill_sequence_id = bic.bill_sequence_id , bic.component_sequence_id = bcb.component_sequence_id , bcb.bill_sequence_id = bsb.bill_sequence_id , bom.structure_type_id = bst.struct