Mysql Select

€8-30 EUR

Fullført

Lagt ut

over 5 år siden

€8-30 EUR

Betalt ved levering

Hi, I have 3 Tables, where I need to extract data from: Table: Users [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL] Table: Projects projects.user_id, projects_name Table: Counts counts.project_id, counts.user_id, [login to view URL] [login to view URL] = projects.user_id [login to view URL] = counts.project_id [login to view URL] = counts.user_id In counts, I have several user_ids to the same project_id -> this should be sum([login to view URL]) I need a Select which provides the following data: from users: name, vorname, title, anr, email, firma from projects: name (where stat = 2) from counts: sum of counts and all the other projects which are not in counts but have stat = 2 So in the End, all of the 764 Rows should be in a table, correctly sum (0 if not in table counts).

Database Programming

MySQL

PHP

Software Architecture

SQL

Prosjekt-ID: 18529240

Om prosjektet

10 forslag

Eksternt prosjekt

Aktiv 5 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

Tildelt til:

@sumon355

Hello, As an expert in SQL, i am very much interested to write the required select query. Looking forward to have a positive response from you. Thanks

€26 EUR om 0 dag

5,0

(324 omtaler)

7,7

10 frilansere byr i gjennomsnitt €23 EUR for denne jobben

@customizedata

I have gone through the description. 1- Select statement will fetch counts (sum) based upon user. Created select statement will have all 764 rows.. Please have a chat with me so that i could discuss with you.. I will start right now.

€25 EUR om 1 dag

5,0

(232 omtaler)

7,3

@seefattechnologi

Hello!! I have 5+ years experience experience in SQL Server Database Design, Database Maintenance, developing SQL queries, stored procedures using SQL Server. I have been working with all version starting from 2005 server. Expertise in development of Web Applications with LINQ. Proficient in Jquery, JavaScript, HTML, AJAX. Looking from positive response from your side. Thanks

€29 EUR om 1 dag

4,9

(61 omtaler)

6,5

@AsifShimon

hi, i have worked with sql databases including mysql and postgresql. i think i can create the sql statements you've asked. let me know if you are interested.

€30 EUR om 1 dag

4,9

(26 omtaler)

4,4

@dalsaniyasonu123

Hello, I am ready to discuss project with you. Being experienced in working on several Web projects related to core php/codeigniter/wordpress etc. Based on that i can quickly help you in getting your project done as you mentioned in the description. I am available to start now and want to discuss more specific details. Looking forward to have further project discussion on chat. Thanks. Sapna Dalsaniya

€28 EUR om 1 dag

4,9

(16 omtaler)

4,0

@ranzhie07

Hi i can do the job in a day or less please consider my bid bro i have 5 years of professional experience in web and windows app development Thanks bro

€22 EUR om 1 dag