Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Incomplete Tables Join
tranvirus wrote:
>
> 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.
Look up OUTER JOIN in the documentation or course notes. Received on Fri Jan 09 2004 - 16:10:09 CST
![]() |
![]() |