sql problem

[Philip Marlowe]

i've two tables:

FRUIT=(ID_FRUIT PK, FRUIT)
example: 0,apple ; 1,banana ; 2,apricot ; 3,melon ; 4,melon ; 5,pear

REL=(ID_REL PK, FRUIT, ID_GROUP) grouping fruits togheter (fruits can stay in more groups or none)
example: 0,apple,a ; 1,pear,a ; 2,melon,b ; 3,apple,b ;4,apricot,b

what's the simplest way to write a query selecting ID_FRUIT,ID_GROUP where i want couples (fruit - group in which it fits given relations defined in REL table) but if fruit don't fit in any group i want the record id_fruit,'no' to be selected/created.
the result of the query will be (in the example above):

0,A ; 0,B ; 1,no ; 2,B ; 3,B ; 4,B ; 5,A

because banana doesn't fit in any group!
_________________
Libreoffice Base HSQLDB not Embedded

[F3K Total]

Hi,
i changed REL, put a FK (FK_ID_FRUIT) instead of FRUIT, because i was too lazy to type in the fruits twice, but i think this works: