Re: Master-Detail relations

Stephanie Kollenz wrote:

> Hi,
> I have master-detail relations in forms. Can anybody tell me how I can write
> such relations in PL/SQL?
> thx
> Steffi

SELECT ...
FROM master_table m, child_table c
WHERE m.field_name = c.field_name (+);

It is called an outer join if you wish to research it at http://tahiti.oracle.com.

Daniel Morgan Received on Mon Jan 13 2003 - 11:37:23 CST