SQL guru??
SQL guru??
Out of context: Reply #4
- Started
- Last post
- 9 Responses
- grafholic0
still not doing it...
The way I went around it is this statement:
select * from [tablename] where status=0 order by gid...that way users who has some value in gid will show up at the bottom of the result.
so there are at least 7 users (and now that i got the data, i'm fine), but statement:
select * from [tablename] where status=0 and gid IS NULL results in 0 records...
drives me crazy.