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 gkittelson 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: *

  • Users: zx10r
  • Order by date
  1. zx10r

    Multiple count from the same field

    Well i still get the same result. What is weird is that if i execute this statement only for this table i get the right results. However once i start joining other tables i get bad results. So the one below works fine" select prospect_id as 'ID', CONCAT_WS(' ',prospect_fn,prospect_ln) as...
  2. zx10r

    Multiple count from the same field

    I have been having some trouble with the query below. select a.advisor_ao as 'AO', case c.existing_client when 'feps' then count(c.existing_client) else 0 end as 'total' from advisor_tb a left join company_tb b on a.advisor_id = b.advisor_id left join comp_seminar_ca_tb c on b.company_id =...
    • zx10r
    • Thread
    • Replies: 2
    • Forum: MySQL

Part and Inventory Search

Back
Top