I need to filter records in grid based on this coding
while select saleline join stab join indim where stab.SalesId==saleline.SalesId && indim.InventDimId==saleline.InventDimId && saleline.ItemId==_sp.PartNumber && saleline.SalesStatus==SalesStatus::Backorder
Well, so what do you need from us? We can't answer your question if you don't ask any.
How to convert this sql statement to query using 3 tables
I don't like this answer but there are hundreds of samples about this, just google 30 seconds...