T-SQL combine tables

Question

I want a+b to get to C. How do I combine A and B ?

Thanks :)

Table A

SELECT init, MIN(p.aarstal) AS startyear
FROM placering p
GROUP BY init
ORDER BY startyear

Table B

SELECT init, MAX(p.aarstal) AS endyear
FROM placering p
GROUP BY init 
ORDER BY endyear

clurd · Accepted Answer · 2019-02-24 18:47:07Z

1

They're the same table, so you just need to combine the logic of both queries. See below for an example.

SELECT 
  p.init, 
  min(p.aarstal) as startyear, 
  max(p.aarstal) as endyear
FROM placering p
GROUP BY init
ORDER BY startyear, endyear

answered Feb 24, 2019 at 18:47

clurd

1462 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gordon Linoff · Accepted Answer · 2019-02-24 18:45:03Z

1

You just select both expressions in a single select:

select init, min(p.aarstal) as startyear, max(p.aarstal) as endyear
from placering p
group BY init
order by startyear

answered Feb 24, 2019 at 18:45

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

GMB · Accepted Answer · 2019-02-24 18:45:11Z

1

Are you just looking for this ?

SELECT init, min(p.aarstal) as startyear, max(p.aarstal) as endyear
FROM placering p
GROUP BY init
ORDER BY startyear, endyear

answered Feb 24, 2019 at 18:45

GMB

224k25 gold badges103 silver badges151 bronze badges