Re: Basic Dual Query Combine into one question

On 23/01/15 11:50, dealTek wrote:

Hi all, (newbie question) - let's say, (for some other reasons I'll skip here) I needed to do two separate queries to the same mysql contacts table (rather than one more elegant combined one) 1 - find everybody from California 2 - find everybody from Texas Then – I would like to combine both of these queries into some kind of an array that I could loop through and display after sorting by last name Q: I am curious the best way to combine the 2 separate queries into 1 afterwards?

Hi dealTek, If you are using MySQL you could look at the UNION clause. It allows you to do two very different queries and combine them into one result set / array. 1st hit I could find. http://www.w3schools.com/sql/sql_union.asp eg: SELECT City, State FROM contacts WHERE State='California' AND cat_lover = 'Yes' UNION ALL SELECT City, State FROM contacts WHERE State='Texas' AND has_hats = 'No' ORDER BY City; Would that achieve the same result in one query? Cheers P