Show data from different tables in mysql

I have a problem wanting to show data from different tables, I'm doing an inventory of products, my tables are the following:

I want my query to show the last sale and the last order of the products, now my query is this:

SELECT pedido.id,MAX(fecha_ped) AS Ultima_Entrada,model,descr,ser,cantidad,det_ped.total,
(SELECT venta.id,MAX(fecha_vta) AS Ultima_Salida,modelo_vta,desc_vta,serie_vta,cantidad_det,det_vta.total)
FROM pedido INNER JOIN det_ped ON(pedido.id=det_ped.id_ped), venta INNER JOIN det_vta ON(venta.id=det_vta.id_vta)
WHERE modelo_vta=model AND ser=serie_vta AND descr=desc_vta ORDER BY venta.id,pedido.id; 

but it returns the following error:

Error Code: 1241

Operand should contain 1 column (s)

Also try with UNION , but do not group me the products as I want, the result I look for is something like this:

grouped.

The union query shows me more or less what I want but not grouped:

SELECT pedido.id,MAX(fecha_ped) AS Ultima_Entrada,model,descr,ser,cantidad,det_ped.total,pedido.estatus FROM pedido INNER JOIN

det_ped ON (order.id = det_ped.id_ped) GROUP BY model, descr, be UNION SELECT sale.id, MAX (date_vta) AS Last_Exit, model_vt, desc_vta, series_vta, quantity_det, total, status FROM sale INNER JOIN det_vta ON (sale.id = det_vta.id_vta) GROUP BY model_vta, series_vta, desc_vta;