I need to pull data from two tables, with one to many relationship by ID. The Status in TBL2 will have status like INROUTE, ARRFORPUP, ARRFORDEL, DELED, PUPED. I need to pull the ARRFORPUP with date and ARRFORDEL with date for comparrison with TBL1.PickByTime and TBL1.DelByTime.

ID, FB, PickByTime, DelByTime

ID Status, Date.

I know how to do it by first running for ARRFORPUP and then for ARRFORDEL I need this to appear as if it came from a single UNION or JOIN.

Can you help?

James E. Squier Sr.