SQL statement to read previous records

Sure, here it is....

select a.* from oeodtp a
join oeodtp b
on a.odordr = b.odordr
where a.oditem in ('03A0','03A2') and b.oditem = '975632'

In this scenario the "03A0" and "03A2" records are the "main" records, and
the "975632" is the "attribute" record. The results of this statement are
that it returns records on orders that have both an "03A0"/"03A2" record
and a "975632" record, but not the correct ones on those orders.

Hope this makes sense.