This is a discussion on Calculation in a view within the MySQL Database forums, part of the Database Forums category; Hello all. I would like to make a view, but rather than viewing the actual content of the record, I ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
Hello all.
I would like to make a view, but rather than viewing the actual content of the record, I would like to calculate the difference between 2 values (such as the difference of price between 2 products). I would rather not have to pass through a second table, and would like to know if it is possible to place the calculation in the creation sequence of the view. Many thanks, Anton |
|
|||
|
On May 14, 9:16 am, Mad Ant <anton.har...@gmail.com> wrote:
> Hello all. > > I would like to make a view, but rather than viewing the actual > content of the record, I would like to calculate the difference > between 2 values (such as the difference of price between 2 products). > I would rather not have to pass through a second table, and would like > to know if it is possible to place the calculation in the creation > sequence of the view. > > Many thanks, > > Anton Yes. Did you try it? |
|
|||
|
Mad Ant wrote:
> Hello all. > > I would like to make a view, but rather than viewing the actual > content of the record, I would like to calculate the difference > between 2 values (such as the difference of price between 2 products). > I would rather not have to pass through a second table, and would like > to know if it is possible to place the calculation in the creation > sequence of the view. > > Many thanks, > > Anton > yes, certainly you can do this. |
![]() |
| Thread Tools | |
| Display Modes | |
|
|