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!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. longdon

    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...
  2. longdon

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

Part and Inventory Search

Back
Top