User Profile

Collapse

Profile Sidebar

Collapse
els12
els12
Last Activity: Mar 18 '10, 03:16 PM
Joined: Mar 12 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • els12
    replied to multiple select statements in one sql query and divsion
    in MySQL
    mmm, I wrote the following SQL statement, but it doesn't work...any ideas?
    Code:
    SELECT(SELECT Count(*)
FROM [Location Data]
WHERE ((([Location Data].Status)="Oper/Obso" Or ([Location Data].Status)="excess" Or ([Location Data].Status)="operating" Or ([Location Data].Status)="inactive") AND (([Location Data].Asset_Code)<>"0000" And ([Location Data].Asset_Code)<>"9999"
    ...
    See more | Go to post
    Last edited by Atli; Mar 12 '10, 06:15 PM. Reason: Added [code] tags.

      Leave a comment:

    • els12
      started a topic multiple select statements in one sql query and divsion
      in MySQL

      multiple select statements in one sql query and divsion

      How do I write 2 distinct select queries in one sql statement, and then also divide the results of one by the other?

      The first query will give me a subset of all the records in the table...the second query will give me a second (larger subset)...and then I want to use those two results to come up with a percentage.

      Any thoughts?
      See more | Go to post
      No activity results to display
      Show More
      Working...