Ver Mensaje Individual
  #8 (permalink)  
Antiguo 27/07/2012, 07:43
martin_sonia
 
Fecha de Ingreso: enero-2012
Mensajes: 45
Antigüedad: 12 años, 3 meses
Puntos: 0
Respuesta: al consultar me enseña datos que fueron modificados

esta es mi consulta:

select distinct jos_vm_order_user_info.last_name, jos_vm_order_user_info.first_name, jos_vm_order_user_info.user_email, jos_vm_orders.user_id, jos_vm_order_item.user_info_id, jos_vm_order_item.order_status, jos_vm_order_item.order_id, jos_vm_order_item.order_item_sku, jos_vm_order_item.order_item_name, jos_vm_order_item.product_quantity, jos_vm_order_item.product_final_price, jos_vm_product.caducidad FROM jos_vm_order_user_info, jos_vm_product, jos_vm_orders, jos_vm_order_item WHERE jos_vm_order_user_info.user_id = jos_vm_orders.user_id AND jos_vm_order_item.user_info_id = jos_vm_orders.user_info_id AND jos_vm_order_item.order_item_sku='Co04'