need help with sql - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

need help with sql

Author

Topic

vitaly87
Starting Member

13 Posts

Posted - 2011-03-03 : 05:41:55

Hello all.
I am using java and I have 2 tables:


create table finalOpinion(
attribute VARCHAR (50),
sentence VARCHAR (560),
model VARCHAR (50));

create table feelingsWords(
feeling VARCHAR (50),
rating INT);

I want to get the rating of words that in the sentence that appear in feeling in the feelingsWords table.
My problem is that the sentence can have other words like:
"screen is good" so I want to get the rate of it from the feeling table.
thanks for helping

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-03-03 : 05:46:48

for example ?

KH
[spoiler]Time is always against us[/spoiler]

vitaly87
Starting Member

13 Posts

Posted - 2011-03-03 : 06:25:38

In the finalOpinion I have in sentence:screen is good ,and in attribute screen.
In the feelingsWords I have: good ,and the rating is 10
so I want to get
attribute:screen ,rating 10

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources