Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Code Help wih Joins

Posted on 2012-04-06
3
Medium Priority
?
315 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Author Comment

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

Accepted Solution

by:
hnasr earned 1000 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

609 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