| re : Querry urgent [message #86488] |
Tue, 05 October 2004 04:03  |
jhsharma
Messages: 58
Registered: June 2004
|
Member |
|
|
hi guru
can i make a querry on selection basis while the selection which i want to make does not existing in the base table ?
example
i want to populate the querry on table t1
product
date
qnty
other master table t2
product
name
category
i want to populate only those records from table t1 which statisfy the category col from the table t2? How do i makethis querry ?
using oracle 8 with d2k
regards
|
|
|
|
| Re: re : Querry urgent [message #86493 is a reply to message #86488] |
Tue, 05 October 2004 05:02  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Use Pre-query and Prepare Default where in it for the block to be populated.
Explain your requirment in detail then I can provide you sample code as well.
Regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
