sql oracle left join issue

Question

0.00/5 (No votes)

See more:

hi guys, i have an issue with sql query:

i have 2 tables, and i want table1 left join table2, mission is to show all table1's rows and for each table1's row, i search records in all table2 until the 1st matched value.

so

CSS

results' row number = talbe1's row number

, just add table2's 1st matched value, but here i get

CSS

results' row number >talbe1's row number

, any help, plz.*

Posted 10-Sep-14 23:09pm

v03051435

Add a Solution

Comments

pradiprenushe 11-Sep-14 22:22pm

provide query.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Magic Wonder · Answer 1 · 2014-09-10T23:14:00

Solution 1

Hi,

Check this Left Outer Join[^]

Hope this will help you.

Cheers

Posted 10-Sep-14 23:14pm

Magic Wonder

Comments

v03051435 11-Sep-14 5:18am

thx, but i kown what left join is, just i have an issue with my question abouve.

Magic Wonder 11-Sep-14 5:22am

Yeah i know but if you will not share the complete details with some sample data if possible then how can be able to help you with your exact problem?

kbrandwijk · Answer 2 · 2014-09-10T23:42:00

Something like:

SQL

SELECT * FROM TableA
LEFT OUTER JOIN 
(SELECT relevantField, ROWNUMBER() OVER(PARTITON BY ID ORDER BY RelevantField2 DESC) RN
 FROM TableB) b
ON TableA.Field = TableB.Field
WHERE b.RN = 1

Without knowing the table structure, you have to put in the correct field names yourself, but the idea is that adding a ROWNUMBER to the second table in the subquery allows you to select only the first record resulting from the join.