I need to make sql query that picks data from 4 tables.
You need to know sql language (I am using Microsoft SQL Server).
I am picking data from 4 tables:
I have already made picking data from 2 tables in this way using INNER JOIN
SELECT [TableAID]
,o.[CompanyID]
,[DateOfSaving]
,[DatumDocument]
,[Value]
.[login to view URL]
,[login to view URL]
,[login to view URL]
FROM [Rijeka].[dbo].[TableA] o
INNER JOIN [Rijeka].[dbo].[Company] p ON [login to view URL] = [login to view URL]
WHERE DatumDocument > '2014-10-25'
But now I dont know how to go further.
I need now to pick data to into a column(s) (if possible) using another JOIN and WHERE clause.
JOIN another table
another 2 tables are:
- Document (one > in relationship)
- DocumentData (many > in relationship)
so I need to pick data from this table and place it into column using probably JOIN and WHERE clause. Since I am not good in SQL, I need a help with it (of some who is expert in sql).
I am a MCSA SQL Server 2014 certified professional, with more than 10 years of experience in SQL related projects and tasks. I work with SQL queries on almost a daily basis.
Hello, how are you? I hope you are well, I understand you I have the knowledge to help you is just that I can connect to your database through teamviewer, do not worry write to me and we agree