Re: mysql_install_db fails mysqld cannot find libgthreads.so

2002-11-15 Thread John Griffiths
Use the same query except replace nvl((c.sr_num),0)) with count(*) John Lance Prais wrote: I have a question about using count in an Intersect Statement. I want to get the total count of the following SQL Statement: How would I do this? SELECT nvl((c.sr_num),0)), FROM s_evt_act a, s_srv_

RE: mysql_install_db fails mysqld cannot find libgthreads.so

2002-11-14 Thread Lance Prais
I have a question about using count in an Intersect Statement. I want to get the total count of the following SQL Statement: How would I do this? SELECT nvl((c.sr_num),0)), FROM s_evt_act a, s_srv_req c WHERE a.sra_sr_id = c.row_id and a.priv_flg = 'N' and a.x_cp_created between (sysd

mysql_install_db fails mysqld cannot find libgthreads.so

2002-11-14 Thread john
>Description: Running the mysql_install_db or configure scripts fail to install database tables. mysqld cannot find libgthreads.so even though it is in /usr/local/lib. Script also complains that libc are not 100 % compatible; I think I have the latest versio