Thanks Madam

It worked

Just for your info In the mean time I tried a solution :-


SELECT BBRL.Location, BBRL.Price, Haldia.Price, Haldia.Location
FROM BBRL INNER JOIN Haldia ON BBRL.Location=Haldia.Location;
UNION ALL
SELECT BBRL.Location, BBRL.Price, Haldia.Price, Haldia.Location
FROM BBRL LEFT JOIN Haldia ON BBRL.Location = Haldia.Location
WHERE (((Haldia.Price) Is Null));
UNION ALL SELECT BBRL.Location, BBRL.Price, Haldia.Price, Haldia.Location
FROM BBRL RIGHT JOIN Haldia ON BBRL.Location = Haldia.Location
WHERE (((BBRL.Price) Is Null));