SQL 2 Excel Pro has now got the ability to generate your spreadsheets from multiple SQL queries - not just one like in the free version.

You specify one main query as usual, then you can add data from other queries using "Extra Cells". You specify which cell the output from the extra query should start (upper left corner) and the data will be populated in your sheet. The query can return just a single value, or multiple rows and columns. Add as many extra queries you need like this.

Here's a simple example:

1. The main query is specified to output two fields from the jos_content table
   
   
   
   
2. We then define "Extra Cell" as a SQL based data. Two SQL queries are defined in this example.  One selects the same thing as the main query, just for demonstration purpose. But it can be anything you want. The second query calculates the max(id) as writes that number in a cell.
   
   
   
   
3. The downloaded spreadsheet looks like this:
   
   
   
   
   

Which database you use for each SQL query is controllable. This enables you to build really complicated reports and pull the information from multiple database sources.

The example above is pretty lame but I hope it illustrates the power and flexibility you have at your fingertips with SQL 2 Excel Pro.

Comments (3)

Subscribe to this comment's feed

entry2015 said:

	... Not understand
	report abuse vote down vote up

October 15, 2011
Votes: +0

aassdd said:

	... The NBA players union and the boss finally alliance did not reach an agreement, the commissioner David stern but the announcement of the new season two weeks before the arrangement was forced to cancel. cheap nfl jersey
	report abuse vote down vote up

October 24, 2011
Votes: +0

Burberry Sale said:

	... YES! I finally found this web page! I've been looking just for this article for so long!!Maybe you will like Coach Factory and Burberry Sale.
	report abuse vote down vote up

May 08, 2012
Votes: +0