Inventory query

I am trying to get a query that contains the following fields from each table.

OITM

itemcode

U_EXT_DESC

OITW

whscode

onhand

iscommited

OSRN

U_stated_cost

location

U_suggested_price

I have multiple warehouses, so I only want items that have qty 1 or more on hand value from MAIN or TECH warehouse to appear in this list

If the onhand value is 0, then I do not want it to appear on this report.

If the location and stated cost and suggested prices are duplicate lines, I want to consolidate to just be ONE row.

Can someone please help me write this query??