The_Joker
asked on
Multiple where clause in a master detail, using Forms Builder
Hi,
I'm developing an application with Forms builder 9i. I have a master-detail relation and I need to have a multiple where clause. Something like:
WHERE ID = IDPLAYER2 OR ID = IDPLAYER3 OR ID = IDPLAYER4
Is it possible?
If so, how?
Many thanks!
Martin
I'm developing an application with Forms builder 9i. I have a master-detail relation and I need to have a multiple where clause. Something like:
WHERE ID = IDPLAYER2 OR ID = IDPLAYER3 OR ID = IDPLAYER4
Is it possible?
If so, how?
Many thanks!
Martin
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Maybe block2 can be based on a view ...
ASKER
it works.
But I need to have an OR not an AND to join togheter
I have a 0:n, 0:n relation between two tables without an intermediate table between
I have put the primary key of one table in the other and there can be up to 4 foreign keys coming from the first table.
It's hard to explain...I don't know if you understand!!
Well thanks.
Martin