# `viw_pitproductstore_customer`（视图）


- **是否可更新：** NO
- **定义者：** `xlyprint@%`

## 字段

| # | 名称 | 类型 | 可空 |
|---|---|---|---|
| 1 | `sProductId` | `varchar(50)` | NO |
| 2 | `sCustomerName` | `varchar(255)` | NO |
| 3 | `sBrandsId` | `varchar(100)` | NO |
| 4 | `sSubsidiaryId` | `varchar(100)` | NO |

## 定义

```sql
select `p`.`sParentId` AS `sProductId`,`c`.`sCustomerName` AS `sCustomerName`,`c`.`sBrandsId` AS `sBrandsId`,`c`.`sSubsidiaryId` AS `sSubsidiaryId` from (`xlyweberp_saas_ai`.`elecustomer` `c` join `xlyweberp_saas_ai`.`eleproductcustomer` `p` on((`p`.`sCustomerId` = `c`.`sId`))) group by `p`.`sParentId` union all select `p`.`sId` AS `sProductId`,`c`.`sCustomerName` AS `sCustomerName`,`c`.`sBrandsId` AS `sBrandsId`,`c`.`sSubsidiaryId` AS `sSubsidiaryId` from (`xlyweberp_saas_ai`.`elecustomer` `c` join `xlyweberp_saas_ai`.`eleproduct` `p` on((`p`.`sCustomerId` = `c`.`sId`))) group by `p`.`sId`
```

## 说明

_暂无人工说明。_
