| what is the relation LOV Query with the master key? [message #85984] |
Thu, 19 August 2004 00:23  |
agnes
Messages: 13
Registered: February 2004
|
Junior Member |
|
|
Hi thre!!
i just want to know what is the relationship using LOV Query and master key?
for example i create 3 table
payment year invoice
payment_id (pk) year_id(pk) inv_id(pk)
payment_id(fk) year_id(fk)
so can u help me how to link the table using LOV Query, when there already got record on the table.?
should u help me?
help me please... i surely appreciate ur help!!
thnk q...
regard from agnes...
|
|
|
|
| Re: what is the relation LOV Query with the master key? [message #85988 is a reply to message #85984] |
Thu, 19 August 2004 03:56  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
I do not understand what do you mean by LOV query.
But I think you want to know how to retrive data by joining your three tables.
Try following query:
Select distinct a.payment_id ,b.year_id,c.inv_id
from payment a,year b,invoice c
where a.payment_id=b.payment_id
and b.year_id=c.year_id;
HTH
regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
