我需要选择客户和产品代码以及下订单的日期，但是我在加入订单时遇到了一些问题。

我的sql选择：

select c.customerNumber, p.productCode, o.orderDate as data_compra
    from customers as c inner join orders as o
    inner join products as p
    where p.productCode =
                any (
                        select p2.productCode from products as p2
                        inner join orders as o
                        inner join orderdetails as odt
                        where o.orderNumber = odt.orderNumber and
                        p2.productCode = odt.productCode
                    )
    and o.orderNumber = 
                any (
                        select o2.orderNumber from orders as o2
                        inner join orderdetails as odt
                        where o.orderNumber = odt.orderNumber and
                        p.productCode = odt.productCode
                    )