比较来自两个不同表的两列中的特定文本 [英] Comparing particular text in two columns from two different tables

问题描述

我有以下表格结构。



CATGORY（第1张桌子）：



类别关键词

肉汁 - veg STEW，KORMA，VEGETABLE



米饭/面条蔬菜PULAV，BATH





表2：





食谱名称准备步骤



鸡肉加热1.加热5分钟。



现在自制备步骤以来，它包含的第一个表格与包含关键词的第一个表格相匹配，它可以提取结果。



类别食谱名称

GRAVY-VEG CHICKEN STEW



我该如何做？



这不是一个关键词。喜欢TAT我必须与每个关键词相匹配。

解决方案

这个要求不会产生正确的信息，就像你给出的例子一样......肉汁怎么样 - veg是鸡炖..



为了更好的结果..精炼表1类别关键词然后使用下面的查询：

 选择 table1.receipename，table1.preparationsteps，table2.category 
 来自 table1 
  left   join  table2  on  table1.receipename  like  ' ％' + table2.category + ' ％'< /跨度> 

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.

解决方案

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:

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

这篇关于比较来自两个不同表的两列中的特定文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！