DataBase Query to verify quantitys

Đã hoàn thành

Mô tả

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