Welcome Guest, Not a member yet? Register   Sign In
Add union() to DB Query Builder
#3

@skunkbad

Code:
-- Filling a dropdown menu about citizenship
(SELECT 'XX' AS country_code, '-- Not specified' AS country_name)
UNION
-- The most probable option(s) is moved on top for user convenience
(SELECT country_code, country_name FROM countries
WHERE country_code IN ('US')
ORDER BY country_name ASC)
UNION
(SELECT country_code, country_name FROM countries
WHERE country_code NOT IN ('US')
ORDER BY country_name ASC)
Reply


Messages In This Thread
Add union() to DB Query Builder - by krystian2160 - 06-14-2017, 08:26 AM
RE: Add union() to DB Query Builder - by skunkbad - 06-14-2017, 11:04 AM
RE: Add union() to DB Query Builder - by zurtri - 06-14-2017, 04:09 PM
RE: Add union() to DB Query Builder - by ivantcholakov - 06-14-2017, 02:56 PM
RE: Add union() to DB Query Builder - by skunkbad - 06-14-2017, 05:58 PM
RE: Add union() to DB Query Builder - by kilishan - 06-14-2017, 08:26 PM



Theme © iAndrew 2016 - Forum software by © MyBB