63,698 reputation
1064148
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 6 months
seen 1 min ago

One of JEHOVAH's Witnesses

Seasoned MySQL DBA (SCMDBA) since 2007-08-11

Profile for RolandoMySQLDBA on Stack Exchange, a network of free, community-driven Q&A sites


Jan
18
comment How can I best combine 3 queries into 1?
OK I am trying to attach all brands by location. Please retry SUBSET QUERY #1...
Jan
18
revised How can I best combine 3 queries into 1?
added 382 characters in body
Jan
18
comment How can I best combine 3 queries into 1?
I removed LIMIT 0,5
Jan
18
revised How can I best combine 3 queries into 1?
deleted 931 characters in body
Jan
18
comment How can I best combine 3 queries into 1?
Do you multiple brandIdentifiers ???
Jan
18
comment How can I best combine 3 queries into 1?
Each unique location may have multiple brands, so you should not expect the Location to be unique unless the Location is the only column or if a location has only one brand. You should see all brands per location. Please refresh the browser, and retry
Jan
18
comment How can I best combine 3 queries into 1?
Perhaps the GROUP BY is incomplete. I changed it. Retry SUBSET QUERY #1...
Jan
18
revised How can I best combine 3 queries into 1?
added 34 characters in body
Jan
18
comment How can I best combine 3 queries into 1?
Please retry SUBSET QUERY #1
Jan
18
comment How can I best combine 3 queries into 1?
Please retry SUBSET QUERY #2. I hope it lets you see the brand identifiers
Jan
18
revised How can I best combine 3 queries into 1?
added 826 characters in body
Jan
18
comment How can I best combine 3 queries into 1?
How many lines came back ???
Jan
18
comment How can I best combine 3 queries into 1?
Please try out SUBSET QUERY #2...
Jan
18
revised How can I best combine 3 queries into 1?
added 826 characters in body
Jan
18
comment How can I best combine 3 queries into 1?
I added a subset of the query. Please try the second query...
Jan
18
revised How can I best combine 3 queries into 1?
added 566 characters in body
Jan
18
revised How can I best combine 3 queries into 1?
deleted 8 characters in body
Jan
18
comment How can I best combine 3 queries into 1?
I moved the LIMIT 0,5 to the bottom. Please try again...
Jan
18
comment How can I best combine 3 queries into 1?
BTW I corrected it in my answer (I added the =)
Jan
18
comment How can I best combine 3 queries into 1?
I copied it from your code. It's missing there too...