Find Jobs
Hire Freelancers

need help on SQL query

$30-250 USD

Igangværende
Slået op over 13 år siden

$30-250 USD

Betales ved levering
This should be a pretty easy project for someone with a working knowledge of SQL. I need guidance on how to correct a query. If you can tell me how to correct my query, I will gladly consider that completion of the project. BACKGROUND: We use an inventory system called Fishbowl inventory. I have created a custom sales report using a program called iReport. The query pulls data from a sales order, sales order line, and payments. When there is one payment applied to the sales order, the report looks fine. However, when multiple payments have been made, the sales order lines are duplicated. If two payments are made, each line is repeated twice. If three payments are made, each line is repeated three times. etc, etc, etc... I have tried some aggregate functions and the DISTINCT key word, but I cannot get this to work. I believe the issue is in how the payment table is being queried: "......COALESCE([login to view URL], 0) AS "POSAmount ....." I have attached a sample report where the duplication is happening. I have also attached the query text itself. If you can tell me how to modify the query on my end, I would consider the job complete. I can modify and test here locally, so no configuration is needed on your end.
Projekt-ID: 748853

Om projektet

10 forslag
Projekt på afstand
Aktiv 14 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
10 freelancere byder i gennemsnit $64 USD på dette job
Brug Avatar.
Please check the PMB. ready to start
$55 USD på 1 dag
4,9 (186 anmeldelser)
8,0
8,0
Brug Avatar.
Hi, please, check your PM
$50 USD på 0 dag
5,0 (329 anmeldelser)
7,5
7,5
Brug Avatar.
hello, check pmb, please
$50 USD på 1 dag
4,9 (71 anmeldelser)
6,9
6,9
Brug Avatar.
i can do it
$70 USD på 2 dage
4,9 (107 anmeldelser)
6,3
6,3
Brug Avatar.
Hi, Please check PM. Regards.
$100 USD på 0 dag
4,2 (54 anmeldelser)
6,1
6,1
Brug Avatar.
Please give me the details. i will correct your queries..
$150 USD på 2 dage
5,0 (5 anmeldelser)
5,0
5,0
Brug Avatar.
Hi, please check PMB.
$40 USD på 1 dag
5,0 (14 anmeldelser)
4,7
4,7
Brug Avatar.
.....please see PM....
$75 USD på 1 dag
4,5 (3 anmeldelser)
3,5
3,5
Brug Avatar.
i can do it .. now a days i m work on sql with concern to the oracle.(orasoft) which is very famous among sql programmers
$70 USD på 15 dage
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for UNITED STATES
Brooklyn, United States
5,0
5
Betalingsmetode verificeret
Medlem siden okt. 5, 2009

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.