Joining Tables Based on Shared Numerical Portion Without Joins or Unions

Query Optimization: Filtering Rows with Common Values Across Columns

Top 1 Record per Product with Ties: Using ROW_NUMBER() Function for SQL Queries

5 Ways to Order Tables Differently with Union Clauses in SQL

Using UNION with Common Table Expressions in SQL Server 2014 Developer: Workarounds and Best Practices