SQL Query Question?

Question

I have created multiple SQL queries that extract information from the tables and create reports. however, I want to send only one email to the person running the query instead of sending multiple reports for the number of queries within the job. Any Ideas how I can do that?

Answer 1

As far as I know, no 'regular' query can send an email. except if you're using SQL server.

check out this site :

http://www.sqlteam.com/item.asp?ItemID=5003

Answer 2

The best book that taught me everything about MySQL is "MySQL Crash Course" by Ben Forta. The book is very straightforward, it shows the keyword, an example query, and an example output. I know you're asking for SQL, not MySQL. Most SQL are similar, and it's only a matter of knowing the few differences of each one. I would start here.

Answer 3

sometimes I have to make a single output from sql although it uses many different data. My advise is to union the queries into a single output. Name the column names something generic and have the data be self explanatory. See below:



select

a.a as column1,

a.b as column2,

a.c as column3

from

table1 a



union



select

b.a as column1,

b.b as column2,

null as column3 /*don't have any data for this column in this query*/

from

table2 b

Answer 4

1. write another query to send e-mail.

2. Send e-mail on execution of last query.

Answer 5

you can easily combine multiple queries...



.

.

.

can u be more clear plz..