Help for WhileSelect Statement, can u help me to write in fetch using while select

Help for WhileSelect Statement, can u help me to write this SQL in fetch using while select
select inventdim.inventbatchid as InvoiceBatch,
custinvoicetrans.invoiceid as InvoiceID,

custinvoicetrans.invoicedate as InvoiceDate

from inventdim left join custinvoicetrans
on inventdim.inventdimid = custinvoicetrans.inventdimid
where inventdim.dataareaid = ‘AB’ and custinvoicetrans.dataareaid = ‘AB’
and inventdim.inventbatchid ! = ‘’ and inventdim.inventbatchid in (
select inventbatchid from inventdim where wmslocationid = ‘PQRS’)