Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Query Help
Started 1 month, 1 week ago by sunfire
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
Site: dBforums - Database Support Community  dBforums - Database Support Community - site profile
Forum: MySQL  MySQL - forum profile
Total authors: 6 authors
Total thread posts: 5 posts
Thread activity: no new posts during last week
Domain info for: dbforums.com

Other posts in this thread:

mnirwan replied 1 month, 1 week ago
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
Size: 450 bytes
Customize:  Customize "<b>Reply 1</b>: Query Help :: MySQL :: dBforums - Database Support Community"

mnirwan mnirwan is offline Registered User replied 1 month, 1 week ago
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
Size: 450 bytes
Customize:  Customize "<b>Reply 2</b>: Query Help :: MySQL :: dBforums - Database Support Community"

r937 replied 1 month, 1 week ago
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
Size: 651 bytes
Customize:  Customize "<b>Reply 3</b>: Query Help :: MySQL :: dBforums - Database Support Community"

r937 r937 is online now SQL Consultant replied 1 month, 1 week ago
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
Size: 651 bytes
Customize:  Customize "<b>Reply 4</b>: Query Help :: MySQL :: dBforums - Database Support Community"

 

Top contributing authors

Name
Posts
sunfire
1
user's latest post:
Query Help
Published (2009-11-13 12:38:00)
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
1
user's latest post:
Query Help
Published (2009-11-13 14:22:00)
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
1
user's latest post:
Query Help
Published (2009-11-13 20:17:00)
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
mnirwan mnirwan is offline...
1
user's latest post:
Query Help
Published (2009-11-13 14:22:00)
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 r937 is online now SQL...
1
user's latest post:
Query Help
Published (2009-11-13 20:17:00)
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
sunfire sunfire is offline...
1
user's latest post:
Query Help
Published (2009-11-13 12:38:00)
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

Related threads on "dBforums - Database Support Community":

SQL Query help: who has NOT logged in this month?  dBforums - Database Support Community - site profile Microsoft Access - forum profile SQL Query help: who has NOT logged in this month?
SQL Query help: who has NOT logged in this month?
SQL query help  dBforums - Database Support Community - site profile comp.databases.ms-access - forum profile SQL query help
SQL query help
ORACLE SQL QUERY Help!!!  dBforums - Database Support Community - site profile comp.databases.oracle.misc - forum profile ORACLE SQL QUERY Help!!!
ORACLE SQL QUERY Help!!!
Report/query help  dBforums - Database Support Community - site profile microsoft.public.access.gettingstarted - forum profile Report/query help
Report/query help
Query Help - New expert-NOT  dBforums - Database Support Community - site profile SQL - forum profile Query Help - New expert-NOT
Query Help - New expert-NOT
Advance query help  dBforums - Database Support Community - site profile Microsoft Access - forum profile Advance query help
Advance query help
Problem in formatting query!!!! Help needed...  dBforums - Database Support Community - site profile comp.lang.c++ - forum profile Problem in formatting query!!!! Help needed...
Problem in formatting query!!!! Help needed...
Get the row counts for each day going back to 6 months...  dBforums - Database Support Community - site profile Microsoft SQL Server - forum profile Get the row counts for each day going back to 6 months (was "query help")
Get the row counts for each day going back to 6 months (was "query help")
Query Help: Mutiple Relationships  dBforums - Database Support Community - site profile comp.databases.ms-access - forum profile Query Help: Mutiple Relationships
Query Help: Mutiple Relationships
Overlapping date ranges (was "SQL Query Help")  dBforums - Database Support Community - site profile SQL - forum profile Overlapping date ranges (was "SQL Query Help")
Overlapping date ranges (was "SQL Query Help")

Related threads on other sites:

Power shower query - help!!  DIYnot.com Forum - site profile Plumbing and Central Heating - forum profile Power shower query - help!!
Power shower query - help!!
Room thermostat query - help much appreciated!  DIYnot.com Forum - site profile Plumbing and Central Heating - forum profile Room thermostat query - help much appreciated!
Room thermostat query - help much appreciated!
Help with my heating query  DIYnot.com Forum - site profile Plumbing and Central Heating - forum profile Help with my heating query
Help with my heating query
#MySQL News: mysql random query help - Webmaster Forum:...  Twitter / peterdobler - site profile peterdobler - forum profile #MySQL News: mysql random query help - Webmaster Forum: Hi, I need to change the query that pulls li.. http://bit.ly/pwNJB 7:04 PM Sep 2nd from twitterfeed
#MySQL News: mysql random query help - Webmaster Forum: Hi, I need to change the query that pulls li.. http://bit.ly/pwNJB 7:04 PM Sep 2nd from twitterfeed
Access Query - Query Help Is Greatly Appreciated!!!!! in...  Discussions in microsoft.public.access.formscoding - site profile microsoft.public.access.formscoding - forum profile Access Query - Query Help Is Greatly Appreciated!!!!! in microsoft.public.access.formscoding
Access Query - Query Help Is Greatly Appreciated!!!!! in microsoft.public.access.formscoding
SQL query help  The Prophecy Forums - site profile The Programming Camp - forum profile SQL query help
SQL query help
Query help - sub query  myITforum.com Community Forum - site profile SMS 2003 - forum profile Query help - sub query
Query help - sub query
I need query help with a query!  http://www.phpfreaks.com - site profile MySQL Help - forum profile I need query help with a query!
I need query help with a query!
Query Help ( Almost finished! some help is needed ) in...  Discussions in microsoft.public.sqlserver.programming - site profile microsoft.public.sqlserver.programming - forum profile Query Help ( Almost finished! some help is needed ) in microsoft.public.sqlserver.programming
Query Help ( Almost finished! some help is needed ) in microsoft.public.sqlserver.programming
SQl Query Help - SQL Server 2005 using 2 DBs in 1 query  The DVD Forums - site profile Computing Forum - forum profile SQl Query Help - SQL Server 2005 using 2 DBs in 1 query
SQl Query Help - SQL Server 2005 using 2 DBs in 1 query
Thread profile page for "Query Help" on http://www.dbforums.com. This report page is a snippet summary view from a single thread "Query Help", located on the Message Board at http://www.dbforums.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity