Incomplete Tables Join

Hi all,

     I'm sorry if this question is too stupid but I can't find the way of creating this query. I want to create a query from two tables, table B has a pointer to table A but Not all the elements in table A are referenced in table B, like this:

TableA
tableAid name

1           one
2           two
3           tree
4           four

TableB
tableBid relatdescr tableAid

1           one-one       1
2           two-two       2
4           four-four     4

I want my resulting table to show tableA.tableAid, tableA.name, tableB.relatdescr for all the elements, including the ones that don't appear in table B showing a blank space or a null value, like this:

tableA.tableAid tableA.name tableB.relatdescr

1               one         one-one
2               two         two-two
3               tree        
4               four        four-four

I think this should be trivial but I don't know how to do it, if you could give me a hand I would really appreciate it.

Best Regards,

Claudio Santana. Received on Fri Jan 09 2004 - 16:00:37 CST