[AccessD] A tricky query, for me!

Hi all,

I have products that are grouped by categories.
I consider the categories.

There are 2 main groups of categories:
1-categories for hypermarket
2-categories for supermarket

there is a set of categories that are in both groups.
but they are also categories that are for hyper only and other for super
only.

I need to display both lists side by side, in an alphabetic order.

But a further constraint(and this is where I need aspirin!):
a single line must show the same category name.
if a category does not exist in the other group, there must a blank in its
cell.

A simple question: I would you do that?

TIA,

Philippe