SELECT o.FSPro_UserID, o.RequesterFName, o.RequesterLName, o.OrderDate, od.shp_qty, od.MerchTitle, od.MerchIdentifier, od.MerchSize FROM tbl_POS_Orders o, tbl_POS_OrderDetail od, tbl_FSPro_Members mems WHERE o.OwnerID = AND o.FSL_TableCode = AND o.status = 'SHP' AND o.orderid = od.orderid AND o.FSPro_UserID = mems.FSPro_UserID AND mems.OwnerID = AND mems.FSL_TableCode = 'BRO';