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

    how do I structure this query?

    Thanks, that worked well!
  2. sorkIndustries

    how do I structure this query?

    My table has the following columns: A boolean,B integer,C varchar(40) I want to get a count of the true and false values in A for each combination of B and C, and the percentage of true values. For example, if the table has the following values: A B C true 35 bob false 35 bob...
  3. sorkIndustries

    SQLite question

    Yes, there is a table that lists all stores.
  4. sorkIndustries

    SQLite question

    Ok, this gives a result of: Product Store Sum Pen Bookstore 1 Pen Supermarket 1 Paper Drugstore 1 Paper Bookstore 1 etc., but the problem is that it doesn't display zero values for Products that don't appear in a particular type of Store, and...
  5. sorkIndustries

    SQLite question

    Hi, I'm posting in General because I didn't see a specific forum for SQLite. Here's my question: I am having difficulty using SQLite. I have a table, let's say it's called Inventory and its fields are Product and Store, like this: Product+Store ---------|--------- Pen | Bookstore Soda...
  6. sorkIndustries

    using GROUP BY to find percentages

    In table UserInfo, I have three fields: Users, Requests, and Approvals. For each user, I want to find the percentage of requests that are approved. Here is some sample data: User|Request|Approval ----+---------+-------- A Y Y B N N C Y N A N...

Part and Inventory Search

Back
Top