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).
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.
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
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.
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
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