left outer join problem

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Separately, these two queries (qryPeriod_All and qryY1)are
working.
But, by using the following query Y1 column is empty and I
don't have any idea why it happens.

SELECT qryPeriod_All.Product_ID,
qryPeriod_All.Distributor_ID, qryY1.Y1
FROM qryPeriod_All LEFT JOIN qryY1 ON
(qryPeriod_All.Distributor_ID = qryY1.Distributor_ID) AND
(qryPeriod_All.Product_ID = qryY1.Product_ID);


Could anybody advise what's a problem there.

Thanks
 
Thanks, I've done it. I've changed it to take Product_ID
and Distributor_ID from the same table. This way, it works
now.
 
Back
Top