Skip to content

Affiche les containers d'une licence en filtrant par produit

1
2
3
4
5
6
7
8
9
SELECT
    container_organization_license_pivot.*,
    container.product_code
FROM
    container_organization_license_pivot
    JOIN container ON container.id = container_organization_license_pivot.container_id
WHERE
    container_organization_license_pivot.organization_license_id = 2251799840005195 -- id de la license
    AND container.product_code IN ('BUSINESS_ENGLISH', 'GENERAL');

Keywords

select organization_license container produit product