>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));
Glad it worked.
If it's not broken, fix it until it is.
My Blog