You will have to bear with me as I am new to SQL.
I have two tables. One table,partopr, contains operation details. The other table, partmtl, contains materials related to the operation.
I have the following select query , this works.
select distinct pub.partopr.partnum...