Comparing particular text in two columns from two different tables

Question

1.00/5 (1 vote)

See more:

I have the following table structure.

CATGORY(1ST TABLE):

CATEGORY KEYWORDS
gravy-veg STEW,KORMA, VEGETABLE

rice/noodles-veg PULAV, BATH

TABLE 2:

RECIPE NAME PREPARATION STEPS

CHICKEN STEW 1. HEAT THE STEW FOR 5 MINS.

NOW SINCE IN PREPARATION STEPS IT'S CONTAINING STEW IT HAS TO MATCH WITH THE FIRST TABLE WHICH IS CONTAINING KEYWORDS STEW AND IT HAS TO EXTRACT THE RESULT AS

CATEGORY RECIPE NAME
GRAVY-VEG CHICKEN STEW

HOW CAN I DO THIS?

THIS S NOT ONYL FOR ONE KEYWORDS STEW. LIKE TAT I HAVE TO MATCH FOR EACH AND EVERY KEYWORDS.

Posted 23-Feb-14 19:19pm

kparun86

Add a Solution

Comments

Maciej Los 24-Feb-14 16:46pm

Do not SHOUT! Improve your question. Don't forget to use formatting!

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)

Gauri Chodanker · Answer 1 · 2014-03-22T10:18:00

Solution 2

The requirement does not yield to correct information as the example you have given...How can Gravy - veg be chicken stew..

For better results.. refine table 1 category key words and then use the query below:

SQL

select table1.receipename, table1.preparationsteps, table2.category
from table1
left join table2 on table1.receipename like '%' + table2.category + '%'

Posted 22-Mar-14 10:18am

Gauri Chodanker

Comments

baliram bhande 23-Mar-14 5:53am

Please edit the post and be clear or ask be specific understand to other person

Schatak 24-Mar-14 2:44am

Its all messed up. what exactly you want ? please specify