• Is there a table which has both keys between productID and customerID?

    Me as an example will not have data against every product in your product table.

    I would maybe buy 1 or 2 things out of millions.

    If there is no Customer_Product table which links the 2 already then unholster the gun and do cross join.

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]