I need to build a proc that performs two selects.
The first one will return 1 or more information from one column (chassis number for example) and with this result I need to make another query reporting one chassis at a time.
For example, if I see more than one result in the first select, I have to query the second using one result at a time.
I have tried in many ways, but I have not achieved any productive results.
Could you please help me?