So 50% is done correctly . Now I need to gain pack values simultaneously ;Like warehouse , pack is related to such data as leafCode , leafName , colorsCode ;So both columns are related to similar parameters and occasionally they are related to common data .

i am afraid that for anyone else who does not have access to your data -- or to an understanding of what you're doing

Maybe I`m going wrong !In simple description :I have 3 tabels : for example (t1 , t2 , t3) .warehouse is obtained from t1 and t2 ; pack is obtained from t3 ; now I need to join these tables to have warehouse and pack simultaneously ; Is the method I choosed to joining these tables correctly ? Is there any alternative solution for it ?

Ok , which data do you need ? or which lines should be described more?Could you please guide me about ambiguous information ?I tried to describe clearly what output I need , I hope my descriptions would be realizable for you because english is not my native language Ah ! this forum is my final trust to solve this problem .

In above step I tried to fetch pack column values from sent_receive_tbl table .But in final step when I try to have warehouse and pack values simultaneously in one individual table with unique data (I mean every unique product has just one row in table) , the result will be wrong ! because I get NULL values for warehouse :

Could you please tell me in which section ? Is it required to place tables structures here ?My favorite result should be :+----------+----------+------------+------+-----------+| leafCode | leafName | colorsCode | pack | warehouse |