Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Counting the number of rows in a UNION
That is a good suggestion... unfortunately, Ingres II must not support subqueries. I think that this is still a limitation with MySQL as well. For interactive use, I have been just selecting on the union, waiting for the output to stop scrolling, and looking at the number of rows returned. I... -
Counting the number of rows in a UNION
Suppose I have 2 tables: products & services. They have different fields, but have the following in common:<br><br>Inv_no: integer<br>Period: char<br><br>Say I need to determine how many invoices I have for a given period. I want to do get the number of rows in the following query:<br><br>SELECT...
