viw_elematerials_eleroduct.md
823 Bytes
viw_elematerials_eleroduct (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
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.