Hi, I am trying to sort a post_title field by alphabetical but it is sticking some out of order at the bottom of the list. any ideas?

Hi Bogdan, 

That makes sense, I didn't even consider it was sorting the URL string and not the company name string. 

This is a MySQL table that I built using the"Generate a query to WordPress database." option.

Thanks

Ok actually I think I see whats happening. it's only displaying the company names where there is the second field available. 

For instance we want column 1 to be company, and column 2 to be country, but not all companies have countries so it is displaying only those that have countries?

If that is the case, how do we set it to display all companies even when there is no country?

Thanks so much!

Hi Bogdan, 

Thanks for following up. 

The code below is the one being auto generated when I build the query from the builder. It even includes them when I don't select a grouping option. 

When i do a VIEW all of the correct information is there, so I think its more the joining is removing records without info?

I guess what I can't figure out how to do is build the query in Wptables and have it show rows where there is an empty cell. Does that make sense?

For instance, we have 132 companies, and 85 with countries associated with them. If I add the country column and group by Company Name, still only 85 companies appear, not 132. 

Thanks so much for your help, I really appreciate it. 

I got it, thanks1