Recent content by omid020

Sorry , I think there is a misunderstanding ! Excuse me if I made you upset , I have a mysql manual but it`s not easy to find and fluence for me , I`ve learned many basic conceptions from SQL lessons in www.w3schools.com and mysql manual but sometimes when my problems get complicated I try to...

No , I don`t use mysql manual , I`ve just tried to find something from simple googling [wink] Thanks for your peerless support , although my database will grow more but I hope to solve other future problems myself [hourglass]

Sorry for my mistake [censored] Can I use UNION ALL for more than 2 SELECT queries ? Is UNION for joining two SELECT statements only !?

Thanks gmmastros , my problem is solved here : http://www.tek-tips.com/viewthread.cfm?qid=1584918

Wonderful result :-> This is code : SELECT leafCode , colorsCode , COALESCE(SUM(`INPUT`), 0) AS `INPUT` , COALESCE(SUM(`OUTPUT`), 0) AS `OUTPUT` , COALESCE(SUM(`INPUT`), 0) - COALESCE(SUM(`OUTPUT`), 0) AS `INVENTORY` FROM ( SELECT rs_leaves.leafCode ...

Ok , I wrote this : SELECT rs_leaves.leafCode, rs_colors.colorsCode, SUM(Distinct assign_details.assAmount) AS OUTPUT FROM assign_details INNER JOIN rs_leaves ON assign_details.leafName = rs_leaves.leafID INNER JOIN rs_colors ON assign_details.leafColor = rs_colors.colorsID GROUP BY...

Hi Rudy , What should I do for second step ?

Mmmm , I like but now I`m going to bed , can I do it tomorrow ? If you have any trouble with next time , I`ll keep it on tonight . What`s your idea ?

No , it`s not possible . Every value in receipt_details.leafName exits in rs_leaves.leafID . receipt_details table content confirm it : +-----------+-------+----------+----------+-----------+-----------+------------+ | detailsID | recID | leafName | leafCode | leafColor | recAmount | recComment...

Thanks :) This is first step : SELECT rs_leaves.leafCode, rs_colors.colorsCode, SUM(Distinct receipt_details.recAmount) AS INPUT FROM receipt_details LEFT JOIN rs_leaves ON receipt_details.leafName = rs_leaves.leafID LEFT JOIN rs_colors ON receipt_details.leafColor = rs_colors.colorsID...

Maybe I`m wrong , but from last post I found that I could write this query : SELECT rs_leaves.leafCode, rs_colors.colorsCode, SUM(Distinct receipt_details.recAmount) AS INPUT, SUM(Distinct assign_details.assAmount) AS OUTPUT, SUM(Distinct receipt_details.recAmount) - SUM(Distinct...

Thanks Rudy for your reply , let`s assume there is a (warehouse), surely every warehouse has some inputs and outputs . To calculate warehouse inventory we use this formula : (inputs - outputs) In my database inputs are in receipt_details table and outputs are in assign_details table ; our...

Hi, 4 required tables content is described below : 1- rs_leaves +--------+----------+-----------------------------------------+ | leafID | leafCode | leafName | +--------+----------+-----------------------------------------+ | 1 | A | WOOD 1...

4 tables content is described below : 1- rs_leaves +--------+----------+-----------------------------------------+ | leafID | leafCode | leafName | +--------+----------+-----------------------------------------+ | 1 | A | WOOD 1 | | 2 | B...

Sry , I forgot to write this query : COALESCE(Sum(Distinct receipt_details.recAmount), 0) - COALESCE(Sum(Distinct assign_details.assAmount), 0) As 'FWarehouse'