# `viw_zlldgroupby_sgdandsmaterialsid` (view)


- **Updatable:** NO

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 1 | `sWorkOrderMaterialsTbId` | `varchar(100)` | NO |
| 2 | `lldsMaterialsId` | `varchar(100)` | YES |
| 3 | `LldQty` | `decimal(40,6)` | YES |
| 4 | `LldsMaterialsStyle` | `varchar(255)` | NO |

## Definition

```sql
select `viw_mitproductionmaterials`.`sWorkOrderMaterialsTbId` AS `sWorkOrderMaterialsTbId`,min(`viw_mitproductionmaterials`.`sMaterialsId`) AS `lldsMaterialsId`,sum(if((`viw_mitproductionmaterials`.`sFormId` = '192116810113315226622476570'),-(`viw_mitproductionmaterials`.`dAuxiliaryQty`),`viw_mitproductionmaterials`.`dAuxiliaryQty`)) AS `LldQty`,`viw_mitproductionmaterials`.`sMaterialsStyle` AS `LldsMaterialsStyle` from `viw_mitproductionmaterials` where (`viw_mitproductionmaterials`.`sWorkOrderNo` <> '') group by `viw_mitproductionmaterials`.`sWorkOrderMaterialsTbId`
```

## Narrative

_No human-written narrative yet._