Re: Views question

I'm doing the sum in the view because it is difficult in the reporting tool
because of lack of relations between the views. What i need is to add same
order types in 2 different views. the thing is the report they just want
sales this year/ last year.

On Tue, Mar 15, 2016 at 1:27 PM, Mike Jones <mike.jones.sysdev@xxxxxxxxx>
wrote:

Yes, views can reference other views.

I've not tried to add a duplicate column name to a view, but I anticipate
it won't allow that. Even if it did allow duplicate column names, you
wouldn't want to do that.

Columns YEAR and AMT are a bit vague. You may want to consider giving them
more specific column names to be more descriptive to those consuming the
view(s).

Mike

date: Tue, 15 Mar 2016 12:35:43 -0400

from: Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
subject: Views question

I have one view. There is a second view I have which I would like to add
some fields from that to the first view - is that allowed?

Data First view

Order type YEAR AMT

INT 2015 100.00
INT 2016 80.00


in Second view, I also have the above data. I would like to add that to

the

first. I guess making a new view. Is that possible?

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.