Yes it works. I created procedure which returns me just distinct barcodes
from shops and did next query:
SELECT A.barcode, count(case when B.shop_id=1 then barcode end), count(case
when B.shop_id=2 then barcode end) FROM get_barcodes A left JOIN shops B ON
(A.barcode = B.barcode) order by A.barcode;
With this a got full join which works and now I just have to reduce the
query with WHERE clause.

All the best,
Damir


[Non-text portions of this message have been removed]