Re: FORMs 5 ..returned rows
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.ruReceived on Tue Sep 29 1998 - 11:07:01 CEST