Milkybar-kid
asked on
SQL Query
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)
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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.