Subject ASAP : Select,Join,Group by and Order by
Author Allies Xposs
For All Master Of DBA...
I have Command SQL "
 a.   Select a.p_sku,b.M_namas,a.p_sell,Sum(a.P_qty) as qty,sum(a.p_qty*a.p_sell) as total from Myss a left Join Pos01 on a.p_sku=b.m_sku where p_room='R301' and p_lok='01' Group By a.p_sku,b.M_namas,a.p_sell
what sql command is wrong ?
because : 1 years (2008) until feb 2009 can load the record data. but this week can not load record data..
Please... help and correctly ....

[Non-text portions of this message have been removed]