Sir,
I would like have help on the following tables:
Table: DEPOSIT
fields:DNO(number), JOINT1(number) , JOINT2(number)

Table: USERS
fields: UID(number),NAME(text)

Relatioship among the tables: NOne

My problem is I want to Display Deposit.DNO, USERS.NAME, USERS.Name from the tables by joining them together by the joint1= user.uid and also joint2=users.uid in a single row for each DNO.

Is this possible. Let me know the query or the stored procedure. Also let me know where to write it.

Bye

------------------
Kaustav

__________________
------------------
Kaustav

If you are in Access,

1) add the deposit table and then the User table twice (USERS and USERS_1).

2) Link the USERS tabnle ID to JOINT1 and then link USERS_1 (the second USERS tbale to JOINT2. Now you can add the fields you need to you query and they will appear as a single row.



Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com

Thankx for your help. But the problem is I am unable to add foreign key reference between the fileds dur to some other reason.
Can you tell me how can this be possible then by a query to the database. If stored procedure is required plz specify.
Byye

------------------
Kaustav