<div>
<div class="content wysiwyg-content">
I can't figure out a SQL query that I'm sure will be very simple<br />
<br />
I have a Company Table and a Financial Year Table<br />
<br />
Company Table contains Company Name and ID<br />
<br />
The Financial Year table contains &nbsp;a company ID column and a Financial year column and a finance column for each company for that year<br />
<br />
I want to display columns for <br />
<br />
Company Name | Finance Figure (This Year) | Finance Figure (Last Year)<br />
<br />
<br />

</div>
</div>


I can't figure out a SQL query that I'm sure will be very simple

I have a Company Table and a Financial Year Table

Company Table contains Company Name and ID

The Financial Year table contains  a company ID column and a Financial year column and a finance column for each company for that year

I want to display columns for 

Company Name | Finance Figure (This Year) | Finance Figure (Last Year)




SQL Query

I can&#39;t figure out a SQL query that I&#39;m sure will be very simple

I have a Company Table and a Financial Year Table

Company Table contains Company Name and ID

The Financial Year table contains  a company ID column and a Financial year column and a finance column for each company for that year

I want to display columns for 

Company Name | Finance Figure (This Year) | Finance Figure (Last Year)




Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.