Home » Developer & Programmer » Forms » Urgent Query (Windows Vista Oracle 9i Dev 6i)
Urgent Query [message #343087] Tue, 26 August 2008 04:24 Go to next message
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
Hi guyz, Cool

I have a problem with query, I have almost 48 tables but no one is attach with other I mean no primary key or foreign key all are common but the one field is common in all table Computer_name is there anyway to query all the tables or select one record from the tables? Or query from selected tables?

If yes Please give the example.....

Waiting for replies. Smile

Re: Urgent Query [message #343176 is a reply to message #343087] Tue, 26 August 2008 09:26 Go to previous message
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

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

Previous Topic: client_host(, NO_SCREEN) still displays windows
Next Topic: Oracle Forms Books
Goto Forum:

Current Time: Sun Jul 23 01:58:18 CDT 2017

Total time taken to generate the page: 0.08368 seconds