SQL Server-与DISTINCT的内部联接 [英] SQL Server - INNER JOIN WITH DISTINCT

问题描述

我很难做到以下几点:

select a.FirstName, a.LastName, v.District
from AddTbl a order by Firstname
inner join (select distinct LastName from
            ValTbl v  where a.LastName = v.LastName)  

我想加入ValTbl，但仅适用于不同的值.

I want to do a join on ValTbl but only for distinct values.

推荐答案

尝试一下:

select distinct a.FirstName, a.LastName, v.District
from AddTbl a 
  inner join ValTbl v
  on a.LastName = v.LastName
order by a.FirstName;

或者这样做(它的作用相同，但是语法不同):

Or this (it does the same, but the syntax is different):

select distinct a.FirstName, a.LastName, v.District
from AddTbl a, ValTbl v
where a.LastName = v.LastName
order by a.FirstName;

这篇关于SQL Server-与DISTINCT的内部联接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！