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’)