Hi Richard,
It is very easy to create a table from a select statement.
Format is :
CREATE TABLE {tablename} AS {your select query}
The { } are just an indication to replace it with your new table name en
your select query.
If you want to append to a table you can use the following :
INSERT INTO {tablename} ( {list of columns} ) {your select query}
Hereby is {list of columns} each columnname of the table separated with a
comma
Met vriendelijke groeten / Kind regards / Mit freundlichen Grüßen /
Cordialement
Lieven Taleman
B.V.B.A. Talsoft
Repingestraat 1B
1570 Vollezele (Belgium)
Flanders Office
Pontstraat 23
9300 Aalst
Tel. +32 (0)53/39.51.52
Mob. +32 (0)475/89.82.07
Acc. sales@xxxxxxxxxx
Web. http://www.talsoft.be
-----Oorspronkelijk bericht-----
Van: foxboro-bounce@xxxxxxxxxxxxx <foxboro-bounce@xxxxxxxxxxxxx> Namens
Richard Peck
Verzonden: dinsdag 1 december 2020 4:14
Aan: foxboro@xxxxxxxxxxxxx
Onderwerp: [foxboro] Create Tables in System Auditor
Hi Friends of Foxboro (colloquially called FoFs) I would like to build a
query to return the activation and return events from specific alarms, this
in itself is quite easy, however the list of alarms to monitor will grow and
hence the query will become quite long and harder to maintain.
Is there a better way? I had thought if I can create my own table then I
can just add the alarms into that table and build a query around it.
Can I create my own Tables?
Is there another way?
Thanks
Richard
_________________________________________________________________________
This mailing list is neither sponsored nor endorsed by Schneider Electric
(formerly The Foxboro Company). Use the info you obtain here at your own
risks. See the disclaimer at www.thecassandraproject.org/disclaimer.html
foxboro mailing list: //www.freelists.org/list/foxboro
to subscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
Scanned by McAfee and confirmed virus-free.
Find out more here: https://bit.ly/2zCJMrO
_________________________________________________________________________
This mailing list is neither sponsored nor endorsed by Schneider Electric
(formerly The Foxboro Company). Use the info you obtain here at your own
risks. See the disclaimer at www.thecassandraproject.org/disclaimer.html
foxboro mailing list: //www.freelists.org/list/foxboro
to subscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
