Sql question about join order

I need to get the last record from my inner join table, not the first one.
This query gets the first row from yAudSd. The table has a timestamp. Can I
order the join somehow or do I need to create an index?

create table wrkart.PTIR32501 as (
select drdid#,RCDCUID as userid,date(drstamp) as myDate,sdControl# as
control#,drshipper as shipper, sdPieces
from drpshp00
inner join whssd00 on drdid#=sddid#
inner join yaudsd on audfid = sddid#
where drstamp >= '2022-10-26-00.00.00'
and audfnm = 'UPS'
and audds like 'UPS label printed Tracking:%'
)
with data;