SELECT DISTINCT FROM LEFT JOIN

[newphpcoder]

Hi..

 

I have query but i got problem in data which I need to DISTINCT.

 

here is my query:

 

SELECT p.PCODE, p.min_lot, p.max_lot, kd.LOT_CODE, kd.wip_chemicalweighing, kd.wip_compounding, kd.wip_extrusion, kd.wip_forming, 
kd.wip_deflashing, kc.count_wip_chemical_weighing, kc.count_wip_compounding, kc.count_wip_extrusion, kc.count_wip_forming, 
kc.count_wip_deflashing, kc.kanban, kc.virtual FROM (SELECT DISTINCT PCODE, min_lot, max_lot FROM plan) AS p
LEFT JOIN (SELECT LOT_CODE, PCODE, wip_chemicalweighing, wip_compounding, wip_extrusion, wip_forming, 
wip_deflashing FROM kanban_data ORDER BY PCODE) AS kd ON (p.PCODE = kd.PCODE)
LEFT JOIN (SELECT DISTINCT PCODE, count_wip_chemical_weighing, count_wip_compounding, count_wip_extrusion, count_wip_forming, 
count_wip_deflashing, kanban, virtual FROM kanban_checker ORDER BY PCODE) AS kc ON p.PCODE = kc.PCODE;

 

I need to distinct data FROM tables plan and kanban_checker.

 

Thank you..

[Muddy_Funster]

Does changing your last LEFT JOIN to an INNER JOIN help?

[newphpcoder]

No....

[Muddy_Funster]

ok, could you give a more accurate description of what exactly you are trying to return?

[newphpcoder]

this is link with the whole code:

 

http://www.phpfreaks.com/forums/index.php?topic=354736.new;topicseen#new

[fenway]

And you're posting this thread twice because...?