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: 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

Bu iş için 10 freelancer ortalamada $64 teklif veriyor


Please check the PMB. ready to start

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(186 Değerlendirme)

Hi, please, check your PM

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(329 Değerlendirme)

hello, check pmb, please

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(71 Değerlendirme)

i can do it

in %bids___i_period_sub_35% gün içinde70%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(107 Değerlendirme)

Hi, Please check PM. Regards.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(54 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)

Hi, please check PMB.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(14 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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 %bids___i_period_sub_35% gün içinde70%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)