Appendix b – writing sql queries, Basic select query – Wavetronix Command Translator (CMD-DT) - User Guide User Manual

Page 151

Advertising
background image

150

APPENDIX

Figure A.8 – Multiple Files to Email

You can send the same file to multiple email addresses (see Figure A.9).

Figure A.9 – File to Multiple Emails

Appendix B – Writing SQL Queries

SQL is a powerful language for performing database operations, and a comprehensive guide

to its functionality is beyond the scope of this manual. Fortunately, very simple SQL state-

ments are all that you need to use TaskBuilder. The following sections present basic steps

used to compose a SQL statement for use in the SQL Query property.

Basic SELECT Query

In the examples below, it is assumed we have a database with two tables:

Advertising