fahad_direct - 4:53 am on Oct 17, 2010 (gmt 0)

Thanks Peter, I have tried by putting index on field id of both tables and checked by explain query which worked well and time from 8 hours have been decreased to around 40 minutes which is great but if i can do it more tweak to get more fast and optimised results.