<div>
Hi,<br />
<br />
I have an example on my download site for Access, &quot;<a href="http://www.ccedv.de/downloads/en" rel="ugc">BestMatchV3</a>&quot;. This gives a point for each found word in a text and then counts the points of the result and sort it so the best match is that with the most points. That should be easily translated in any other database.<br />
<br />
Cheers,<br />
<br />
Christian
</div>


Hi,

I have an example on my download site for Access, "BestMatchV3 [http://www.ccedv.de/downloads/en]". This gives a point for each found word in a text and then counts the points of the result and sort it so the best match is that with the most points. That should be easily translated in any other database.

Cheers,

Christian

<div>
Hi Christian, there is already a table for the keywords. So there is no need to scan the text. Also, I'm looking for help with the SQL.
</div>


Hi Christian, there is already a table for the keywords. So there is no need to scan the text. Also, I'm looking for help with the SQL.

<div>
Hi Pawan, that query doesn't really make sense to me. It is specifically the related table News :: Keywords table that needs to be queried, I think.
</div>


Hi Pawan, that query doesn't really make sense to me. It is specifically the related table News :: Keywords table that needs to be queried, I think.

<div>
can you send rows from all the three table and how these tables are joined and the expected output.
</div>


can you send rows from all the three table and how these tables are joined and the expected output.

<div>
Pawan, I just figured it out using your suggestion.
</div>


Pawan, I just figured it out using your suggestion.

<div>
<div class="content wysiwyg-content">
I have a news table with a related keywords table.<br />
<br />
So on each news page I just want to be able to list the top 3 related news items ordered by the most matching keywords. I'm just not sure how to best query this?<br />
<br />
So there are three tables:<br />
<br />
News table<br />
<br />
Keywords table<br />
<br />
News :: Keywords table
</div>
</div>


I have a news table with a related keywords table.

So on each news page I just want to be able to list the top 3 related news items ordered by the most matching keywords. I'm just not sure how to best query this?

So there are three tables:

News table

Keywords table

News :: Keywords table

Help with SQL query, order by number matches

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.