how to select first 9 numbers from other table from database using sql query?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

i want to fetch first 9 numbers from matching with other column please help me to find out thank you....?

SQL

SELECT  MAINFILE.facno,GLMAST.fglhead
FROM    MAINFILE INNER JOIN GLMAST
    ON  LEFT(MAINFILE.facno,9) like GLMAST.fglcode
    AND GLMAST.fglhead='" & ComboBox2.Text & "' "

Posted 12-Nov-14 18:37pm

lakshjoshi

Updated 12-Nov-14 20:05pm

Jörgen Andersson

v2

Add a Solution

Comments

Sanchayeeta 13-Nov-14 0:59am

Can you please provide your table structure.

lakshjoshi 13-Nov-14 1:07am

i mathcing glcode='010000101' with facno='010000101000001' where i want to select frist 9 numbers to match with glcode from facno...i hope my concept understood..

Jörgen Andersson 13-Nov-14 2:08am

You're wide open to SQL Injection, please change your query to use parameters.
Obligatory XKCD reference: http://xkcd.com/327/

Jörgen Andersson 13-Nov-14 2:15am

Is fglcode always 9 numbers?

lakshjoshi 13-Nov-14 2:19am

yes...

Shweta N Mishra 13-Nov-14 3:37am

I think your query should work, You can use the "=" operator also instead of like.

What is the issue you are facing.

4 solutions

Solution 4

thank you all..problem solved

SQL

"SELECT  DISTINCT GLMAST.fglcode,GLMAST.fglhead FROM MAINFILE INNER JOIN GLMAST ON  LEFT(MAINFILE.facno,9) like GLMAST.fglcode AND GLMAST.fglhead = '" & ComboBox2.Text & "'  "

Posted 13-Nov-14 19:21pm

lakshjoshi

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)

Jörgen Andersson · Accepted Answer · 2014-11-12T22:36:00

Like Shweta has already commented, I also don't see an immediate reason to why it shouldn't work.
So please update your question with what problem you're getting.
Meanwhile you can try this:

SQL

SELECT  MAINFILE.facno,GLMAST.fglhead
FROM    MAINFILE INNER JOIN GLMAST
    ON  MAINFILE.facno like GLMAST.fglcode + '%'
    AND GLMAST.fglhead='" & ComboBox2.Text & "' "

syed shanu · Accepted Answer · 2014-11-12T21:36:00

Solution 1

try this

SQL

SELECT Top 9 MAINFILE.facno,GLMAST.fglhead
FROM    MAINFILE INNER JOIN GLMAST
    ON  LEFT(MAINFILE.facno,9) like GLMAST.fglcode
    AND GLMAST.fglhead='" & ComboBox2.Text & "' "
ORDER BY MAINFILE.facno

Posted 12-Nov-14 21:36pm

syed shanu

lakshjoshi · Accepted Answer · 2014-11-12T23:29:00

Solution 3

yes its works thank to all....

SELECT DISTINCT GLMAST.fglcode,GLMAST.fglhead FROM MAINFILE INNER JOIN GLMAST ON LEFT(MAINFILE.facno,9) like GLMAST.fglcode AND GLMAST.fglhead = '" & ComboBox2.Text & "' "

Posted 12-Nov-14 23:29pm

lakshjoshi

how to select first 9 numbers from other table from database using sql query?

4 solutions

Solution 2

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us