Query Help

sunfire · #1 (**permalink**) 11-13-09, 11:38

Hello,
I'm not sure what function I'm looking for but what I'm wanting to do is group all of the a.version by NULL vs Not NULL no matter what the version value is.

What do I need to do?

select c.name, c.address, a.version
From clients c
Left Join app_Info a
ON c.uid = a.uid

mnirwan · #2 (**permalink**) 11-13-09, 13:22

Code:

select c.name, c.address, IF(a.version IS NULL, 'version null', 'version not null') as version
From clients c
Left Join app_Info a
ON c.uid = a.uid
GROUP BY 3

r937 · #3 (**permalink**) 11-13-09, 19:17

Code:

SELECT c.name
     , c.address
     , a.version
  FROM clients c 
LEFT OUTER
  JOIN app_Info a
    ON a.uid = c.uid 
ORDER
    BY a.version

all the NULL versions will be grouped together

Internet Services

Web Development

Digital Marketing

Consumer Tech