My query returns 4 to 6 lines per Doc_no. Each line represents a progression through the shop with each line having a start time and end time. In column "Description", One line is "Assembly", one is "Inspect", one is "Quote", one is "Ship" and so on. How do I modify the code to only look at the line that contains "Assembly", and return the end date for that line? My code looks something like this
, wh.End date
from wo_hdr wh
join wo_hdr_status ws on (wh.doc_no = ws.doc_no)
where ws.wo_status_start date < ??the end date of the line were wh.Description = Assembly??
I'm a beginner as you can tell. Thanks for your help.