473,466 Members | 1,296 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Please help. How can we write SELECT query for this type issue.

4 New Member
Dear all,

I have two databases. One contains name, id and the other contains id and certain other details. How can we write query which gives all names with details irrespective of the availability of details in the second databases. When I tried this issue with WHEN condition I am getting the details of only those records which have details in both DATABASES.

JK
Oct 8 '07 #1
9 1322
mjkriab
4 New Member
Dear all,

I have two databases. One contains name, id and the other contains id and certain other details. How can we write query which gives all names with details irrespective of the availability of details in the second databases. When I tried this issue with WHEN condition I am getting the details of only those records which have details in both DATABASES.

JK
Oct 8 '07 #2
chella
51 New Member
Dear all,

I have two databases. One contains name, id and the other contains id and certain other details. How can we write query which gives all names with details irrespective of the availability of details in the second databases. When I tried this issue with WHEN condition I am getting the details of only those records which have details in both DATABASES.

JK
Hi,
I think you need to use outer joins.

Can you post the part of the query which creates the issue? I think that would give us a good picture about the problem.

Regards,
Chella
Oct 8 '07 #3
debasisdas
8,127 Recognized Expert Expert
Question moved to Oracle Forum.
Oct 8 '07 #4
r035198x
13,262 MVP
Dear all,

I have two databases. One contains name, id and the other contains id and certain other details. How can we write query which gives all names with details irrespective of the availability of details in the second databases. When I tried this issue with WHEN condition I am getting the details of only those records which have details in both DATABASES.

JK
So the details are in different databases or in different tables?
What are your tables then?
Post also the query that you tried.
Oct 8 '07 #5
debasisdas
8,127 Recognized Expert Expert
Use joins to retrive the desired records on the ID field.
Oct 8 '07 #6
debasisdas
8,127 Recognized Expert Expert
Please do not post duplicate threads .

Both the threads are merged for better management of the forum.
Oct 8 '07 #7
r035198x
13,262 MVP
Use joins to retrive the desired records on the ID field.
So it is possible to join tables from different databases using joins?
Oct 8 '07 #8
debasisdas
8,127 Recognized Expert Expert
So it is possible to join tables from different databases using joins?
Yes that is possible by using DBLINK.

You need to use the name of the dblink with the table name for join.
Oct 8 '07 #9
r035198x
13,262 MVP
Yes that is possible by using DBLINK.

You need to use the name of the dblink with the table name for join.
That's probably what the OP is looking for then, because they did say the data is in different databases.
Oct 8 '07 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

9
by: sk | last post by:
I have an applicaton in which I collect data for different parameters for a set of devices. The data are entered into a single table, each set of name, value pairs time-stamped and associated with...
2
by: Amanda | last post by:
From a guy in Microsoft newsgroups: | In *comp.databases.ibm-db2* there are always IBM guys | from the Toronto labs on line.Post with the | -for the love of god please help- | line...
1
by: sid_mulpuru | last post by:
I am trying to read data from a DB2 Blob Data type Field (using wsad 5.1.0) using getBlob() which when executed gives an SQL Exception 2005-01-07 15:48:40,506 ERROR - Error in...
9
by: Dom Boyce | last post by:
Hi First up, I am using MS Access 2002. I have a database which records analyst rating changes for a list of companies on a daily basis. Unfortunately, the database has been set up (by my...
1
by: David Van D | last post by:
Hi there, A few weeks until I begin my journey towards a degree in Computer Science at Canterbury University in New Zealand, Anyway the course tutors are going to be teaching us JAVA wth bluej...
17
by: so many sites so little time | last post by:
all right so the script is pretty simple it goes it retrives what the id of the post is and it lets you edit it well no it doesnt. now if you go to www.kirewire.com/pp2/index/php you will see a...
6
by: jenipriya | last post by:
Hi all... its very urgent.. please........i m a beginner in oracle.... Anyone please help me wit dese codes i hv tried... and correct the errors... The table structures i hav Employee (EmpID,...
5
by: loveshack | last post by:
Can anyone help me please (i am quite a novice, but having fun learning). Im not sure if this is an ASP problem, a javascript problem or a browser problem. Firstly, everything i have written...
1
by: jrnowlan | last post by:
I have the following VB code that takes form data from a picklist and uses the input values to query an access database. Currently everything works, but it writes the results to the same page when...
4
by: mattehz | last post by:
Hey there, I am trying to upload old source files and came across these errors: Warning: Invalid argument supplied for foreach() in /home/mattehz/public_html/acssr/trunk/inc_html.php on line 59...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.