FORMs 5 ..returned rows

From: <mdesouza_at_YAHOO.COM>
Date: Mon, 28 Sep 1998 12:51:59 GMT
Message-ID: <6uo0pe$5dn$1_at_nnrp1.dejanews.com>



Hi

[Quoted] 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 Mon Sep 28 1998 - 14:51:59 CEST

Original text of this message