# `viw_elematerials_eleroduct` (view)


- **Updatable:** NO

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 1 | `sId` | `varchar(50)` | NO |
| 2 | `sMaterialsName` | `varchar(100)` | NO |
| 3 | `sMaterialsUnit` | `varchar(50)` | YES |

## Definition

```sql
select `elematerials`.`sId` AS `sId`,`elematerials`.`sMaterialsName` AS `sMaterialsName`,`elematerials`.`sMaterialsUnit` AS `sMaterialsUnit` from `elematerials` union select `eleproduct`.`sId` AS `sId`,`eleproduct`.`sProductName` AS `sProductName`,`eleproduct`.`sProductUnit` AS `sProductUnit` from `eleproduct`
```

## Narrative

_No human-written narrative yet._