Problem for selecting records from table

Question

0.00/5 (No votes)

See more:

In my table has following

Ledger_Transaction_hdr

Lth_comp   LTH_SNO  Lth_ledgerid  Lth_trantype  lth_total  lth_paid  lth_received
3          7            1              PR          10000      10000      0
3          7            5              PR           2000      0         10000
3          8            1              SR           2000      10000      0
3          8            15             SR           3000      0         10000
3          5            3              SL           10000      10000       0
3          5            4               SL          1000       0        10000
3          5            5               SLRCPT          1200       1200       0
3          5            5               SLRCPT      1200       0       1200

IN THE ABOVE TABLE I WANT TO DETAILS FOR LEDGER ID 1 like following

Lth_comp   LTH_SNO  Lth_ledgerid  Lth_trantype  lth_total  lth_paid  lth_received
3          7            5              PR           2000      0         10000
3          8            15             PR           3000      0         10000

how to get it I give the ledgerid 1
it returns the transaction from 1 depending on lth_sno how to do it please help me anybody thankyou

If i give this query

Select * from ledger_transaction_hdr where lth_Transrlno in (select lth_transrlno from ledger_transaction_hdr where lth_ledgerid=1)

It give the folloing

Lth_comp   LTH_SNO  Lth_ledgerid  Lth_trantype  lth_total  lth_paid  lth_received
3          7            5              PR           2000      0         10000
3          8            15             PR           3000      0         10000
3          5            5              SLRCPT         1200       1200       0
3          5            5              SLRCPT        1200       0       1200

But I don't want like that. I want First Solutions

Posted 19-Jul-12 1:44am

devausha

Updated 20-Jul-12 19:46pm

v13

Add a Solution

Comments

Arul R Ece 19-Jul-12 7:47am

Can't understand your Question.please explain in detail

devausha 20-Jul-12 3:23am

In this table I want to get the records is not equalto ledger id 1 but sno of the ledger id 1 is 7 which is equal to which rows has sno 7

devausha 19-Jul-12 7:49am

I want to get the transaction with ledgerid 1

4 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)

E.F. Nijboer · Answer 1 · 2012-07-19T01:49:00

Solution 1

I think its join you are looking for. Have a look here:
http://msdn.microsoft.com/en-us/library/ms191517%28v=sql.105%29.aspx[^]

Good luck!

Posted 19-Jul-12 1:49am

E.F. Nijboer

Santhosh Kumar Jayaraman · Answer 2 · 2012-07-20T00:14:00

Solution 2

SQL

select * from ledger_transaction_hdr a where lth_sno in (Select lth_sno from ledger_transaction_hdr where lth_ledger_id=1)

or

select * from ledger_transaction_hdr a where exists (Select lth_sno from ledger_transaction_hdr where lth_ledger_id=1)

Posted 20-Jul-12 0:14am

Santhosh Kumar Jayaraman

Comments

devausha 20-Jul-12 6:59am

I try this solution But there is some problem if there are two many
I update the above questions

Santhosh Kumar Jayaraman 20-Jul-12 7:01am

I didnt get you. What was the issue you are facing now?

devausha 20-Jul-12 7:07am

I explain it on the question. Please see that

Santhosh Kumar Jayaraman 20-Jul-12 7:48am

i have posted new answer.Please check and let me know

Vasim889 · Answer 3 · 2012-07-20T00:20:00

Solution 3

SQL

select * from  Ledger_Transaction_hdr where  Lth_trantype ='PR' and lth_paid =0

you want like that

Posted 20-Jul-12 0:20am

Vasim889

Updated 20-Jul-12 0:31am

v3

Santhosh Kumar Jayaraman · Answer 4 · 2012-07-20T01:47:00

Solution 4

SQL

Select * from ledger_transaction_hdr where lth_Transrlno in (select lth_transrlno from ledger_transaction_hdr where lth_ledgerid=1) and  lth_ledgerid<>1

Posted 20-Jul-12 1:47am

Santhosh Kumar Jayaraman

Updated 20-Jul-12 1:48am

v2

Comments

devausha 20-Jul-12 7:59am

I already try this one but it is not working

Santhosh Kumar Jayaraman 20-Jul-12 8:11am

Can you share screenshot of ur query and output?

devausha 21-Jul-12 0:13am

Yes

devausha 21-Jul-12 0:36am

But How to upload image?

Santhosh Kumar Jayaraman 23-Jul-12 1:40am

http://tinypic.com/