I have a table that tracks ordering activity. The initial order entry into the table has the status field set to 15 signifying Active. Once the order is complete, a second entry for the order is added into the same table with the status field set to 3 signifying Complete. I am trying to write a query that will select all entries with a status of 15 but do have any corresponding orders that have a status of 3.
This is a vendor controlled database and therefore unable to make any changes to it’s design.
Any suggestions?
a TOAD newbie…
Thanks