# `viw_pitproductstore_customer` (view)


- **Updatable:** NO

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 1 | `sProductId` | `varchar(50)` | NO |
| 2 | `sCustomerName` | `varchar(255)` | NO |
| 3 | `sBrandsId` | `varchar(100)` | NO |
| 4 | `sSubsidiaryId` | `varchar(100)` | NO |

## Definition

```sql
select `p`.`sParentId` AS `sProductId`,`c`.`sCustomerName` AS `sCustomerName`,`c`.`sBrandsId` AS `sBrandsId`,`c`.`sSubsidiaryId` AS `sSubsidiaryId` from (`elecustomer` `c` join `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 (`elecustomer` `c` join `eleproduct` `p` on((`p`.`sCustomerId` = `c`.`sId`))) group by `p`.`sId`
```

## Narrative

_No human-written narrative yet._
