Re: [SQL*FORMS] A multi-table block?

There is no need to create a view for your operations.

You can have a block based on table1. In your WHERE criteria in that block, use an union statement.

for example, if you access has table emp1 as the base table, in the where criteria of emp1 block, perform the following.

where emp_no = :emp.emp_no
union
select emp_no, emp_name
from emp

When execute query is initiated on your block, it will query all records from both emp1 and emp2.

Hope it satisfies your problem.

Regards

N.Prabhakar
Socgen-Crosby Securities,
Singapore

Tel : Off 65 - 390 2228

      Res 65 - 560 7785. Received on Sat Nov 02 1996 - 00:00:00 CET