SQL query result not as expected

Question

0.00/5 (No votes)

See more:

i have 12 record. i want to show Amount,date and installment no 12 times in a sequence but loan id only one time in a row. help me with this.

thanX in advance

Select c.Loan_id,i.Installment_no,i.Date,i.Amount from Customer c,Installments i,Loan l where l.Loan_id=c.Loan_id and c.Loan_id=i.Loan_id;

Posted 27-Dec-12 5:40am

zeshanazam

Updated 27-Dec-12 5:45am

Sandeep Mewara

v2

Add a Solution

Comments

zeshanazam 27-Dec-12 12:24pm

here is data

Installment_no Loan_id Date Amount
1 1234-55 2013-01-13 86688
2 1234-55 2013-02-13 86688
3 1234-55 2013-03-13 86688
4 1234-55 2013-04-13 86688
5 1234-55 2013-05-13 86688
6 1234-55 2013-06-13 86688
7 1234-55 2013-07-13 86688
8 1234-55 2013-08-13 86688
9 1234-55 2013-09-13 86688
10 1234-55 2013-10-13 86688
11 1234-55 2013-11-13 86688
12 1234-55 2013-12-13 86688

Bassofa 27-Dec-12 12:30pm

Can you please clarify your question?

zeshanazam 27-Dec-12 12:35pm

Value of Loan_id should appear only one time.

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)

snorkie · Accepted Answer · 2012-12-27T06:53:00

zeshanazam,

Ideally, you would just limit the output in the code. But if you have to only have it output on one row, try the following. I'm assuming you're using SQL Server. Different database may change the syntax.

SQL

Select 	CASE i.Installment_no
	  WHEN 1 THEN c.Loan_id
	  ELSE null
	END AS Loan_ID
	,i.Installment_no
	,i.Date
	,i.Amount 
from Customer c
	,Installments i
	,Loan l 
where l.Loan_id = c.Loan_id 
and c.Loan_id = i.Loan_id;

Hogan