Taking inner subset result of one join and combining this with an outer join

• ScottPletcher

  SSC Guru

  Points: 101207

  More actions

  January 20, 2021 at 10:42 pm

  #3835671

  You really need to provide directly usable table structures and data.  That is:

  CREATE TABLE and INSERT statement(s)

  CREATE TABLE #df1 /*or just df1*/

  ( version varchar(10) NOT NULL, host ... )

  INSERT INTO #df1 VALUES('pat', 'a16', '12/1/2019'),('fam', ...)

  CREATE TABLE #df2 ...

   

  SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".