dimanche 18 septembre 2016

SQL Server JOIN returns Cartesian result

I am trying to combine two views and it returns a Cartesian result.

View 1 192 (this view has inner join with the order id for the expired keys)

View 2 70 (this view has inner join with order id and sale date to get the renewed keys)

When I join these views (any of the joins), it results in 13340 rows returned.

Thanks

Aucun commentaire:

Enregistrer un commentaire