不确定查询结果

i have this working query

Sum(`sales`.`quantity`) AS totquantity,
`transactions`.`price` AS price,
Sum(`sales`.`quantity`)  *  `transactions`.`price` AS grantot
from (`sales` join `transactions` on((`transactions`.`idtransaction` = `sales`.`idtransaction`)))
where ((`sales`.`createon` > '01/01/2017') and (`sales`.`createon` < 'now()'))
group by `sales`.`idtransaction`

but it would be usefully to consult to create this view

     select `products`.`idproduct` AS `idproduct`,`transactions`.`idtransaction` AS 
`idtransaction`,`transactions`.`idline` AS `idline`,
    `products`.`name` AS `name`,`products`.`code` AS `code`,`transactions`.`price` AS `price`,`sales`.`quantity` AS `quantity`,`sales`.`createon` AS `createon` 
    from (`sales` left join (`transactions` left join `products` on((`products`.`idproduct` = `transactions`.`idproduct`))) on((`transactions`.`idtransaction` = `sales`.`idtransaction`)))

and make a query on the view like

select * from myview where `sales`.`createon` > '01/01/2017' and `sales`.`createon` < 'now()'

now my question is are the two result the same?

thx in advance

Your original query uses two tables and full joins.

However, the view has already three tables and left joins.

That’s enough to conclude there is no guarantee they produce the same result in general.

You can provide more precise inputs to get more precise answer.