DataBase Query to verify quantitys

Đã Đóng

hello , i am looking to fix a query to verify some stock accounts those 4 to 5 tables some sums to check if the stock is right

must compare the current stock vrs the sum of initial+adjuments stock and if is wrong update with the right value.

SELECT [url removed, login to view],[url removed, login to view] as cantidadInv,sum([url removed, login to view]) as compraSt , sum([url removed, login to view]) as vendido,

SUM(IF([url removed, login to view] = 'addition', [url removed, login to view], 0))-SUM(IF([url removed, login to view] = 'subtraction', [url removed, login to view], 0))+sum([url removed, login to view]) as ajustes

FROM `sma_purchase_items` compra

inner join sma_products productos on [url removed, login to view] = compra.product_id

left join sma_sale_items vendidos on [url removed, login to view] = vendidos.product_id

left join sma_adjustment_items ajustes on vendidos.product_id = ajustes.product_id

group by [url removed, login to view]

this is mostly the query must be fixed due in some rows shows another information. if need i can share the db and explain via teamviewer or similar

Kỹ năng: Quản trị cơ sở dữ liệu, Phát triển cơ sở dữ liệu, Lập trình cơ sở dữ liệu, MySQL

Xem thêm: websites to find information for an academic essay, crawl websites information, websites information web design, websites information fortune company, websites information, websites dat find jobs, fetch websites information, medical transcription websites information, websites information fortune 500 company, websites can find possible husband wife, script query database size, input output query database, wordpress query database, php drop list query database, oscommerce database tables products, information find swing tag label, script php query database, need products sale, php query database drop, user forms query database, online products sale, websites can find friendster com layouts, oscommerce database missing products, execution query database failed modx, arcgis serve query database

Mã Dự Án: #13120054

Đã trao cho:

moeenahmed21

I am an experienced database developer and administrator. I will create query and solve your problem. Feel free to contact me for further discussion. Regards, Moeen Ahmed

$30 USD trong 1 ngày
(8 Đánh Giá)
3.3

20 freelancer đang chào giá trung bình $31 cho công việc này

mahmoudgamal008

I have more than 5 years of professional and practical experience in SQL and database development. I wrote hundreds and hundreds of SQL queries, I have more than 1800 answers in Stackoverflow(Q&A Site), you can vie Thêm

$30 USD trong 1 ngày
(29 Đánh Giá)
5.2
fanninson45

SHOWCASE An experienced Microsoft Certified Professional with Database Programming and Administration skills across both MS SQL and Business Intelligence Development. Having the ability to take the technical lead in p Thêm

$25 USD trong 1 ngày
(14 Đánh Giá)
5.5
point5nyble

Hello, I have been working with a MNC based company since last ~ 6 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in Thêm

$35 USD trong 1 ngày
(32 Đánh Giá)
4.8
phiona06

Hi! I'm senior lecturer on databases with 10+ years experience in different DBMS (including MySQL). As I see in your query have one mistake - in group statement need to be the same columns as in select statement (witho Thêm

$25 USD trong 0 ngày
(16 Đánh Giá)
4.3
nojnish

Hi, I can help you with the task as I have 15+ years experience and 5 years in MySQL. can you share what additional info you are getting for the query shared as it would help resolve the problem otherwise I can prov Thêm

$22 USD trong 1 ngày
(2 Đánh Giá)
3.5
$60 USD trong 1 ngày
(4 Đánh Giá)
3.4
celalaybar

Hello. Thank you very much for taking time to read my proposal. I can help you. I am a fulltime freelancer. You can check my portfolio and reviews. We can discuss further details. Hopefully, both of us Thêm

$29 USD trong 1 ngày
(4 Đánh Giá)
2.3
swarm22

I am database developer , query writing and optimizing with mysql , oracle . I will able to do this task. Could you let me know , when could we arrange meeting regarding project

$30 USD trong 1 ngày
(13 Đánh Giá)
2.8
$25 USD trong 2 ngày
(0 Đánh Giá)
0.0
$35 USD trong 1 ngày
(0 Đánh Giá)
0.0
arindamkumar

A proposal has not yet been provided

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
$25 USD trong 1 ngày
(0 Đánh Giá)
0.0
aap31374

I have 10+ years database development experience in sql server, Mysql and Postgres. I have also worked in SSIS and SSRS. I assure that i will give you fully satisfaction about this assignment.

$25 USD trong 1 ngày
(0 Đánh Giá)
0.0
$30 USD trong 3 ngày
(0 Đánh Giá)
0.0
kunjmishra

Dear Client, With 6 years of experience in database (sql) and looking at the sample query provided it seems doable. Looking forward to hear from you. Regards, Kunj.

$15 USD trong 1 ngày
(0 Đánh Giá)
0.0
AppsUNeed

This looks reasonably simple to carry out. I would probably simplify this by creating a view in your database that will do all of the aggregation so that you don't need the long string of LEFT JOINs but will confirm w Thêm

$25 USD trong 1 ngày
(0 Đánh Giá)
0.0
$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
delphijdeveloper

I graduated from the department of Mathematics and specialized in Computer applications. I have been writing financial and business applications on Delphi and Mysql languages since last 20 years for small and big comp Thêm

$45 USD trong 2 ngày
(0 Đánh Giá)
0.0
im146

hi, I have experience in developing complex queries and I am interested in this task please ping me so we can discuss it further and can start the work thanks

$45 USD trong 1 ngày
(0 Đánh Giá)
0.0