# `viw_elematerials_eleroduct` (view)

> VIEW


- **Updatable:** NO
- **Definer:** `xlyprint@%`

## Columns

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

## Definition

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

## Narrative

_No human-written narrative yet._