Re: FORMs 5 ..returned rows
Date: Thu, 01 Oct 1998 11:40:12 +0800
Message-ID: <3612F99C.7EA29F3E_at_ccis.adisys.com.au>
The way I handle this is to put the following in the where clause:
col1, col2 in (
select alias2.col1, alias2.col2
from alias2)
I am assuming that alias1 is the table on which your block is based. Therefore, col1 and col2 which are outside the sub-query refer to 2 columns included in the block. If this is not the case then you would need to put the whole of your select statement into the sub-query but replace the * with column(s) which match column(s) in the block. For example:
colA in (
select colX from table1 alias1 , table2 alias2 where alias1.col1 = alias2.col2 and alias1.col2 = alias2.col2)
where colA is a column in the block.
Hope this is clear enough.
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
Received on Thu Oct 01 1998 - 05:40:12 CEST