Create a MYSQL Query Statement which relates 7 tables (diagram explains relation)

Selesai Dipasang Jun 2, 2013 Dibayar saat pengiriman
Selesai Dibayar saat pengiriman

Create a MYSQL query statement which combines columns and data from 7 tables in a new query table. The result is only the query statement fully operational that I will test in PHPMyAdmin.

Attached are two files:

1) "[url removed, login to view]" which is an export from phpmyadmin- mysql with the 7 tables

2) "estrutura de [url removed, login to view]" Diagram which shows the relation and the structure of the tables and the strutucture of the new query-table

Attention: In the query table (green) there are new columns names for the new columns.

MySQL

ID Proyek: #4582977

Tentang proyek

14 proposal Proyek online Aktif Jun 2, 2013

Diberikan kepada:

DrAKkareS

Hi, I can give you the MySQL query. I have a lot of experience in PHP/MySQL. I'll need the attachments. Please let me know any comment/doubts. Regards, David

$35 USD dalam 1 hari
(102 Ulasan)
4.9

14 freelancer rata-rata menawar $84 untuk pekerjaan ini

sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$96 USD dalam 2 hari
(11 Ulasan)
4.9
spcinc

Hello. MySQL Expert here. I can do it. Best Regards.

$103 USD dalam 1 hari
(2 Ulasan)
3.5
VnBestSolutions

Dear Sir, We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Lebih banyak

$100 USD dalam 2 hari
(3 Ulasan)
3.0
riskypathak

Wait.. Wait... Dont award project to anyone.. I am working on it.. Will provide you result soon...

$35 USD dalam 1 hari
(4 Ulasan)
2.8
vickkey7

I am ready to start this project..........

$74 USD dalam 2 hari
(1 Ulasan)
2.8
rofreelance

Please check your PM.

$88 USD dalam 3 hari
(1 Ulasan)
0.6
bmartynvw

Can be done. Refer PM

$74 USD dalam 3 hari
(0 Ulasan)
0.0
ankitmalikfun

Please check my PM , thanks

$72 USD dalam 2 hari
(0 Ulasan)
0.0
rubarita

This job is a piece of cake for me. Could you please visit my profile to see the reviews?

$155 USD dalam 1 hari
(0 Ulasan)
1.3
nupito

Oracle Expert!

$166 USD dalam 1 hari
(0 Ulasan)
0.0
surjeetsingh90

I am working with MySQL more than 2 yrs.

$155 USD dalam 3 hari
(0 Ulasan)
0.0
Wendiz1

I have a lot of experience in PHP/MySQL. I can give you the sql query. Regards.

$50 USD dalam 1 hari
(0 Ulasan)
0.0
tree1891

Dear sir, I'm ready.

$35 USD dalam 1 hari
(0 Ulasan)
0.0
mdakteruzzaman

Hi, I'm expert in web programming and MySql administration. pls check pmb

$35 USD dalam 1 hari
(0 Ulasan)
0.0