MstfaBaban
New Coder
[CODE lang="sql" title="SQL"]select `invoice`.`date` AS `vdate`,`invoice_details`.`product_id` AS `product_id`,
sum(`invoice_details`.`quantity`) AS `sell`,
0 AS `Purchase` from (`invoice_details` join `invoice` on((`invoice_details`.`invoice_id` = `invoice`.`invoice_id`)))
group by `invoice_details`.`product_id`,`invoice`.`date` union select `product_purchase`.`purchase_date` AS `purchase_date`,`product_purchase_details`.`product_id` AS `product_id`,
0 AS `0`,sum(`product_purchase_details`.`quantity`) AS `purchase` from (`product_purchase_details` join `product_purchase` on((`product_purchase_details`.`purchase_id` = `product_purchase`.`purchase_id`))) group by `product_purchase_details`.`product_id`,
`product_purchase`.`purchase_date`[/CODE]
guys if i needed to add another col to this view
from product_purchase_details.expire_date
how do i do this
dont give me code
just tell me how i can implement this in mysql
sum(`invoice_details`.`quantity`) AS `sell`,
0 AS `Purchase` from (`invoice_details` join `invoice` on((`invoice_details`.`invoice_id` = `invoice`.`invoice_id`)))
group by `invoice_details`.`product_id`,`invoice`.`date` union select `product_purchase`.`purchase_date` AS `purchase_date`,`product_purchase_details`.`product_id` AS `product_id`,
0 AS `0`,sum(`product_purchase_details`.`quantity`) AS `purchase` from (`product_purchase_details` join `product_purchase` on((`product_purchase_details`.`purchase_id` = `product_purchase`.`purchase_id`))) group by `product_purchase_details`.`product_id`,
`product_purchase`.`purchase_date`[/CODE]
guys if i needed to add another col to this view
from product_purchase_details.expire_date
how do i do this
dont give me code
just tell me how i can implement this in mysql
Last edited by a moderator: