) AS searchable,
memberid FROM members
I get massive errors.
I'm reading MySQL from New Riders, but I can't seem to figure this
out based on the information they've provided.
Alnisa
--
.
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph
--
.
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph) 415.337.7412 (fx) 415.337.7927
(url) http://www.nonprofit-techworld.org
(url) http://www.nonprofit-tech.org
(url) http://www.tech-library.org
empid, COUNT(empid) FROM emp_cont GROUP BY empid HAVING
COUNT(empid) 1
I tend to use either group by or having, so forgot that having can be
used to limit a group by. But this statement should work for you, as
well.
Alnisa
--
.
Alnisa Allgood
these different
implementations of SQL occasional kill me.
Alnisa
--
.
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph) 415.337.7412 (fx) 415.337.7927
(url) http://www.nonprofit-techworld.org
(url) http://www.nonprofit
, mdfaq_category cat
3 where faq_cat.cat_id (+) = cat.id
4 group by cat.id, cat.name;
Funny, I think I just sent you something somewhat similar. Glad it worked.
Alnisa
--
.
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph
--
.
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph) 415.337.7412 (fx) 415.337.7927
(url) http://www.nonprofit-techworld.org
(url) http://www.nonprofit-tech.org
(url) http://www.tech-library.org
.
Nonprofit Tech E
web root.
Alnisa
--
.
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph) 415.337.7412 (fx) 415.337.7927
(url) http://www.nonprofit-techworld.org
(url) http://www.nonprofit-tech.org
(url) http://www.tech-library.org
/
to test.
Alnisa
--
.
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph) 415.337.7412 (fx) 415.337.7927
(url) http://www.nonprofit-techworld.org
(url) http://www.nonprofit-tech.org
(url) http://www.tech-library.org
--
.
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph) 415.337.7412 (fx) 415.337.7927
(url) http://www.nonprofit-techworld.org
(url) http://www.nonprofit-tech.org
(url) http://www.tech-library.org
, telecommunications, protocols, routers, etc.
The above explains the more complicated query between three tables,
but you can also do this with a single table, or two tables.
Alnisa
--
.
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph
.
Alnisa
--
.
Alnisa Allgood
Executive Director
Nonprofit Tech
(ph) 415.337.7412 (fx) 415.337.7927
(url) http://www.nonprofit-techworld.org
(url) http://www.nonprofit-tech.org
(url) http://www.tech-library.org
11 matches
Mail list logo