Devam Ediyor

need help on SQL query

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([url removed, login to view], 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.

Beceriler: PHP, Yazılım Mimarisi, SQL

Daha fazlasını görün: sql inventory system, sample inventory system using php, php inventory system sample, n query, need sql help, inventory system using php, on sql, job inventory, job help, inventory job, sql work needed, SQL Query, report sql, query table, my sql work, ireport, get sql help, fishbowl, data query, aggregate, sql created, project using sql, help using, help modify, need key

İşveren Hakkında:
( 5 değerlendirme ) Brooklyn, United States

Proje NO: #748853

10 freelancers are bidding on average $64 for this job

phpexp

Please check the PMB. ready to start

1 gün içinde 55$ USD
(186 Değerlendirme)
8.0
NickolaS

Hi, please, check your PM

in 0 gün içinde50$ USD
(329 Değerlendirme)
7.5
nsweb

hello, check pmb, please

1 gün içinde 50$ USD
(71 Değerlendirme)
6.9
GFsoul

i can do it

in 2 gün içinde70$ USD
(107 Değerlendirme)
6.3
bhavinhjoshi

Hi, Please check PM. Regards.

in 0 gün içinde100$ USD
(54 Değerlendirme)
6.1
qualite

Please give me the details. i will correct your queries..

in 2 gün içinde150$ USD
(5 Değerlendirme)
5.0
inosov

Hi, please check PMB.

1 gün içinde 40$ USD
(14 Değerlendirme)
4.7
prafullgoyal

.....please see PM....

1 gün içinde 75$ USD
(3 Değerlendirme)
3.5
fengyanliang

SQL expert, I have checked your [url removed, login to view] file, let's go

1 gün içinde 50$ USD
(7 Değerlendirme)
3.4
salebrat

I think i know your mistake where you [url removed, login to view] you want quickly result send me message.

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
Muhammadharis123

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

in 15 gün içinde70$ USD
(0 Değerlendirme)
0.0