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

  1. quexal

    Pivot table query assistance!

    Hey Tony! Thanks for the post... I wound up arriving at a solution that's pretty close to what you had there... here's what I'm now using! SELECT pl_id, group_concat(re_id) AS re_ids FROM pprops GROUP BY pl_id HAVING find_in_set(19, re_ids) AND find_in_set(22, re_ids) Working like a charm...
  2. quexal

    Pivot table query assistance!

    Well, I'm stumped on this one, the solution is probably staring me in the face, but I figgured I'd pop in here to ask quick-like. Here's the table I'm working with: Table Name: pprops pp_id pl_id re_id ----- ----- ----- 1 45 19 2 45 22 3 34 19 4 35 29 I'm using...

Part and Inventory Search

Back
Top