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 TouchToneTommy 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
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...
