Sub query and like operator

Question

1.00/5 (4 votes)

See more:

i have two table and find record with like operator and record show in grid view
datagridview show a part table record but his coulumn name modalID, but i have type a textbox modalname this mathod solution

part table

brand modalId partId partname qty mrp

modal table

modalId brandId modalname

What I have tried:

SQL

select modalname from modal1 where modalId =(select modalId from partstock where modalname='')

Posted 25-Jun-18 7:43am

Member 13886465

Updated 25-Jun-18 20:07pm

Maciej Los

v2

Add a Solution

Comments

Member 13886465 25-Jun-18 13:43pm

please give me answer fast

Bryian Tan 25-Jun-18 15:28pm

Is modalname field in both table?

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

kmoorevs · Answer 1 · 2018-06-25T09:55:00

Solution 1

You need a join between your two tables, in this case probably an inner join...like this:
from modal inner join part on modal.modalid = part.modalid

The where can just reference the modalname then without a subquery.

Also, to use a subquery as in your example replace '=' with 'in'.

Posted 25-Jun-18 9:55am

kmoorevs

Comments

Maciej Los 26-Jun-18 2:06am

5ed!

Member 13886465 29-Jun-18 0:03am

str = "Select * from part_stock where modalid=(select modalid from modal1 where modalname like '" & TextBox1.Text & "%') and part_name like '" & TextBox2.Text & "%' and qty like'" & TextBox3.Text & "%' and mrp like'" & TextBox4.Text & "%'"

this is perfect query but one error
i am type the textbox single single letter and error is one record can be return this sub query

Member 13886465 29-Jun-18 0:04am

but error is only sub query

Mohibur Rashid · Answer 2 · 2018-06-25T15:19:00

Solution 2

You need to learn
* SQL Joins[^]; in this case you will work with inner join
* SQL LIKE Operator[^]

You are talking about SQL query, you have tagged as SmartWatch. Wrong tagging.
You should also mention what database you are using.

Posted 25-Jun-18 15:19pm

Mohibur Rashid

Comments

Maciej Los 26-Jun-18 2:06am

5ed!