Query doesn't return records in sql.......

Question

0.00/5 (No votes)

See more:

I want all records from two tables depending on Bill_no.
I write this query,but it doesn't return any record..

SQL

select st.custName,st.slsDate,st.slsmName,st.vat,st.totalAmt,st.NetAmt,sd.* from salesItemDetails sd,salesDetails st where sd.bill_no=st.bill_no and(sd.bill_no='BI/12-13/000002')

Thanks in advanced...

Posted 30-Mar-13 4:47am

JayantaChatterjee

Add a Solution

Comments

André Kraak 30-Mar-13 10:59am

Do you get any results when you leave out and(sd.bill_no='BI/12-13/000002')?

JayantaChatterjee 30-Mar-13 11:04am

No..
The results is blank..... :-(

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)

OriginalGriff · Accepted Answer · 2013-03-30T05:15:00

Solution 1

Check your data.

It would appear that there are no records where the bill_no matches exactly. Have a look with SSMS and double check you are using the right database. If you are absolutely sure after that, we would need to see the actual code your are using to retrieve the records.

Posted 30-Mar-13 5:15am

OriginalGriff

Comments

JayantaChatterjee 30-Mar-13 11:25am

Thanks Sir...
Its My mistake. I didn't insert data in salesItemDetails table, that why it doesn't return records..

OriginalGriff 30-Mar-13 11:43am

We've all done it! :laugh: