Don't run the query ?
Seriously, you need to understand the concept of joins.
You have no link between SFC_STEP and SFC. Maybe SFC_STEPs have an SFC_ID that says they relate to a particular row in the SFC table. You may know that, but you haven't 'told' that query to use that relationship.




Reply With Quote