Sql Command 1

[dwooten]

Hello,

Does anyone know if a sql command can contain multiple sql statements? Or do I need to create a separate command for each sql statement?

Thank you for any input.

 

[fisheromacse]

SQL Command? as in for use as a datasource?
or do you mean SQL Expression?

 

[dwooten]

as in for use as a datasource.

 

[lbass]

Why do you have multiple queries? Your intent would determine how to approach writing the command.

It is best to use one command as your datasource instead of linking them, since in the latter case, the linking occurs locally and slows your report. If you wrote separate queries within one command, I think each query would run once for each record in the other query--creating a Cartesian join and dramatically slowing your report. If you have summaries you want to create with the command, set them up as subqueries in your Select clause.

-LB