Never been to CodeSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

Joining Tables using a Like statement (See related posts)

-- This SQL code allows you to join a table to another table by finding columns that contain another column's information
-- (instead of where the columns are equal)

SELECT *
FROM Table1
INNER JOIN Table2 ON Table1.col LIKE '%' + Table2.col + '%'
to sql mssql by taurin on Fri Aug 15 15:09:56 +0000 2008

You need to create an account or log in to post comments to this site.


Related Posts