Solved

Code Help wih Joins

Posted on 2012-04-06
3
306 Views
Last Modified: 2012-04-09
Hi - I am struggling with trying to get this join to work as it should.

I am attaching the code and the files needed to reproduce it.

I am trying to match up for every entry of diff.compr_fld_nm and bring in the fn.g_field_name for it.

Also trying to match up every entry of test_SCN1_id and bring in the ship_ID for it as well.  

All I am getting is duplicates.
TEST.zip
0
Comment
Question by:j2911
  • 2
3 Comments
 

Author Comment

by:j2911
ID: 37817860
The code I have is working except for the join part.
0
 
LVL 30

Accepted Solution

by:
hnasr earned 500 total points
ID: 37820411
This question requires much time to recreate the problem.
Try to limit the number of tables, and fields in each table.
Check the simplified query then add more fields and tables.

In your current query you are only joining two tables that are used as one entity joined with other table without specifying the ON clause. The data is filtered using the where clause. This creates duplicate records and most are insignificant.

Try to use joins.

You can list the contents of few tables (3-4) with few records (~4 in each) and list the expected output.
0
 

Author Comment

by:j2911
ID: 37821819
Although I appreciate your help - I don't do well learning with theory but something I can see.  Would someone have the time to help me out here?
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question