|
Re: Urgent Query [message #343176 is a reply to message #343087] |
Tue, 26 August 2008 09:26 |
|
Yea it is... use joins.... in SQL
Select a.computer_name, .....
from table1 a, table2 b, table3 c
where a.computer_name = b.computer_name
and a.computer_name = c.computer_name;
In Forms use Relations option under block and create your relations. For this you dont need to have any primary keys or foreign keys defined in the database. [EDITED by DJM: fixed formatting]
[Updated on: Mon, 01 September 2008 01:00] by Moderator Report message to a moderator
|
|
|