Code: Select all
$query = "SELECT SOHEAD.CUST_ID, SOHEAD.SO_NO, SOHEAD.SHIP_ID, SOHEAD.CANC_DATE, SOHEAD.`STATUS`, SOHEAD.PO_NO, SOHEAD.REQRD_DATE, TRACK.TRACK_SO_NO, TRACK.TRACK_STATUS, TRACK.TRACK_DATE, TRACK.TRACK_TIME, TRACK.TRACK_NOTES, TRACK.TRACK_NUMBER, TRACK.TRACK_PO_NO, TRACK.TRACK_CUST_ID FROM SOHEAD Left Join TRACK ON SOHEAD.SO_NO = TRACK.TRACK_SO_NO WHERE SOHEAD.CUST_ID ='$id' AND STATUS='S' ORDER BY SO_NO DESC";
I am trying to pull TRACK_SO_NO 1, 2, and 3 and that is working fine.
The question I am not able to resolve is that all I want to produce is the last entry for TRACK_SO_NO. It passes through several stations 1-20. So if 14 is the last one I want to print 14 but not 1-13. Specifically TRACK_STATUS is the field I am trying to limit.
I have thought about breaking it into two queries but then the water gets muddy.
Any ideas?