0 - 1 of 1 tags for NetFx

SELECT a.cas_pkeyb.amt
FROM vt_notdisp_ship_to a,
scref_bvws.b_curr_trans b
WHERE (a.ship_to_addr <>'''' AND a.ship_to_addr LIKE ('%b.ship_to_addr%'))
OR (a.ship_to_code <> '''' AND a.ship_to_code LIKE ('%b.ship_to_code%'))
QUALIFY ROW_NUMBER() OVER (ORDER BY a.amount DESC) <=10;