| Subject | ASAP : Select,Join,Group by and Order by |
|---|---|
| Author | Allies Xposs |
| Post date | 2009-03-12T17:08:07Z |
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 ....
Thanks...
[Non-text portions of this message have been removed]
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 ....
Thanks...
[Non-text portions of this message have been removed]