SQL query problem in Access - Urgent
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
|