Join 3 tables and fetch for latest record from 3rd table if not exists display latest from 2nd table

Question

4.73/5 (4 votes)

See more:

Please find the fiddle here
My requirement is I need to display the latest record from 3rd table if exists based on first table ID and second table ID, if not I would like to display the latest record from second table. I have given the sample tables and the query I have written but i am not getting the actual result as per my need so some one can help me
SQL Fiddle

This is what I am getting and I have written what I expected

http://i.stack.imgur.com/KCFkA.png[^]

Posted 28-Jan-16 21:05pm

Krishna Chaitanya

Updated 28-Jan-16 22:08pm

v3

Add a Solution

Comments

dan!sh 29-Jan-16 3:51am

+5 for being one of the few who post proper question.

jaket-cp 29-Jan-16 6:55am

why do you consider this to be a proper question?
if you have to link off to another site to get the full details of the question

1 solution

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)

*dan!sh* · Answer 1 · 2016-01-28T22:31:00

Solution 1

I can't access the image URL from work. But I guess I may have understood what you need. You can add more columns to the query.

SQL

SELECT	ISNULL(CDESC,BDESC) 
FROM	TBLA JOIN TBLB 
ON		TBLA.AID = TBLB.AID
		LEFT JOIN TBLC 
ON		(TBLB.BID = TBLC.BID AND TBLB.AID = TBLC.AID)
ORDER BY TBLC.CID DESC,TBLB.BID DESC

Posted 28-Jan-16 22:31pm

dan!sh

Comments

Krishna Chaitanya 29-Jan-16 5:24am

Hi danish I need only one row against each tblA.AID and it should be the latest, the query you have given me is giving multiple rows. Here is the fiddle I am attaching what I need is I need only 'Post2 Regarding A' from AID 10
<link>http://sqlfiddle.com/#!6/33b0e/3</link>