The following are supported for compatibility with SQL used by other database products. These alternatives are non-standard. The OFFSET clause and the LIMIT clause can only be specified in the outermost fullselect of a query.
You can try adding ORDER BY yaudsd.theTimeStampCol DESC FETCH FIRST 1 ROW
ONLY before the end of the query.
El vie, 28 oct 2022 a las 6:01, Art Tostaine, Jr. (<atostaine@xxxxxxxxx>)
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
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:%'
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
Help support midrange.com by shopping at amazon.com with our affiliate
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.