|
|
|
|
|
|
|
|
query= select t2.* from t_main_prod t1 left join t_prod t2 on( t1.prod_code = t2.prod_code ) where m_gbn='m1'
query= select t2.* from t_main_prod t1 left join t_prod t2 on( t1.prod_code = t2.prod_code ) where m_gbn='m2'
query= select t2.* from t_main_prod t1 left join t_prod t2 on( t1.prod_code = t2.prod_code ) where m_gbn='m3'
query= select t2.* from t_main_prod t1 left join t_prod t2 on( t1.prod_code = t2.prod_code ) where m_gbn='m4'
|
 |
|
|
|
|
|
|
|
|
 |
|
|
|
