Re: FORMs 5 ..returned rows

From: Valery A. Sorokin <vsorokin_at_dd.ru>
Date: Tue, 29 Sep 1998 12:07:01 +0300
Message-ID: <3610A335.73DF8805_at_dd.ru>


Try to use VIEW if you want to use two tables with the one block.

I hope this will helps you.

mdesouza_at_YAHOO.COM wrote:
>
> Hi
>
> Small problem here
>
> I need to restrict what data is returned where I execute query on a block
>
> Now You will probably say use the where clause in the block properties
>
> the problem is that I need to use two tables
>
> ie
> some thing like this
>
> select * from table1 alias1 , table2 alias2
> where alias1.col1 = alias2.col2
> and alias1.col2 = alias2.col2
>
> Now now you I do this in forms .. so Ican restrict what get returned when i
> execute_query
>
> any help appreciated
>
> michael Dsouza
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

-- 
Valery A. Sorokin
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoftmpc.msk.su
http://www.dd.ru
Received on Tue Sep 29 1998 - 11:07:01 CEST

Original text of this message