Write a small SQL query crossing tables.

I have a database that i need to query data out of crossing tables.

The data needs to be displayed as shown in the screenshots.

The Tables needed would be

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

OrderID, Customer, Job Name, Prepress Working, PDF Proof, Hard Copy Proof, Approved, Ready 2 Plate, Plating, Surface Completed

The data needs to be displayed in a list. I believe you would need to somehow display the Milestones table pivoted.

I will display this in a webpage that will refresh every minute.

Kemahiran: Pelayan Microsoft SQL, SQL

Lihat lagi: small sql query, display salary decimal oracle sql write query, sql write query, vbs sql write, small sql table, small sql database reviews, small sql database projects, query snmp sql, query simple sql

Tentang Majikan:
( 1 ulasan ) Kettering, United Kingdom

ID Projek: #12902092

Dianugerahkan kepada:


hello, I can do your job by querying and joining your tables within mean time... So i think i am perfect for ur job. waiting for your reply. Thanks

£38 GBP dalam 3 hari
(1 Ulasan)

29 pekerja bebas membida secara purata £97 untuk pekerjaan ini


Hello, I am very much interested to do this work, i have good experience in writing complex sql queries. I am not fully clear about the required output. I need to see the other tables too. We can discuss more. Th Lagi

£120 GBP dalam 3 hari
(157 Ulasan)

Dear hiring manager, I am a full stack software developer with 12+ years experience with software development, 8+ years experience with .net framework and sql server and 6+ years experience with asp.net mvc I got Lagi

£166 GBP dalam 7 hari
(22 Ulasan)

I am having more than 7 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utili Lagi

£170 GBP dalam sehari
(28 Ulasan)

Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: W Lagi

£105 GBP dalam sehari
(5 Ulasan)

I am sql server dba having more then 10 yrs of experience

£33 GBP dalam sehari
(28 Ulasan)

Hi, I am a professional SQL expert with over 3 years of experience. I have read your requirements and interested to work for you as I am expert of SQL, MS SQL Server and can write your mentioned query very professional Lagi

£20 GBP dalam 0 hari
(5 Ulasan)
£150 GBP dalam sehari
(3 Ulasan)

rich experience in mysql

£172 GBP dalam 2 hari
(2 Ulasan)

Hello Sir I am ready to start this project right away, Please send me database and ftp access to get started. Please check my profile for work and experience. Regards Ashwin

£77 GBP dalam sehari
(4 Ulasan)

Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 7.2 years experience in SQL and 4.4 years experience in SSRS, SSIS. Please let me know more details and when we will start.

£24 GBP dalam 0 hari
(17 Ulasan)

hello, i have more then 6 year experience in this field and easily can do this task ready to start now thanks.......

£155 GBP dalam 3 hari
(3 Ulasan)

I have 3 years of professional experience as a database developer and admin with IBM. I could help you with building queries and optimising them fairly quickly. I'd love to hear back from you soon! Regards Sahil

£83 GBP dalam 0 hari
(5 Ulasan)
£25 GBP dalam 2 hari
(7 Ulasan)

dear, i have experience 10 yers in sql server database and writing complex query for banking systems. best regards, Hassan

£55 GBP dalam sehari
(4 Ulasan)
£150 GBP dalam 3 hari
(2 Ulasan)

Hi, i am Sourabh Kumar Sharma a Software Developer and Software Entrepreneur. I will like to work on your project and deliver the project. I also have a group of talented professional software development engineers w Lagi

£200 GBP dalam 7 hari
(1 Ulasan)

Hi, I'm a french software engineer, and I new to this website. I just create my compagny, and I develop software for compagnies. I worked for 10 years as a software developer as well as MySQL and SQL Server database Lagi

£50 GBP dalam sehari
(1 Ulasan)

hi, I have experience in developing complex queries and I am interested in this task please ping me so we can discuss it further and can start the work thanks

£88 GBP dalam sehari
(0 Ulasan)

Development PHP with more 10 years experence. Skills: PHP, JavaScript, JQuery, MySQL, Ajax, Boostrap Manager Servers GNU/Linux Centos & Debian

£20 GBP dalam sehari
(0 Ulasan)

Hello Sir/Madam! Greetings!!! Thanks for sharing the project. I can start your project right now. I am very much interested in your project concept and of course want to get involved in this project. I got more than Lagi

£20 GBP dalam sehari
(0 Ulasan)