RE: Select and COUNT

SELECT tableA.*, COUNT(*) AS Tot FROM tableB LEFT OUTER JOIN tableA ON tableA.uid=tableB.uid GROUP BY tableA.uid Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.

Re: Select and COUNT

Hi, spacemarc wrote: 2007/6/8, Baron Schwartz <[EMAIL PROTECTED]>: Use a LEFT OUTER JOIN, but reverse it; join from tableA to tableB. You may be looking for a FULL OUTER JOIN, I'm not sure. MySQL doesn't support that, but see: http://www.xaprb.com/blog/2006/05/26/how-to-write-full-outer-joi

Re: Select and COUNT

Hi spacemarc, spacemarc wrote: Hi all, I have this query: SELECT tableA.*, COUNT(*) AS Tot FROM tableB LEFT JOIN tableA ON tableA.uid=tableB.uid GROUP BY tableA.uid This query shows only the users (tableA) that are in tableB with at least 1 record (like total) but not the users that have 0 rec

RE: Select and count duplicates

select distinct(headlines), count(headlines) from table group by headlines -Original Message- From: David Shapiro [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 8:40 AM To: 'Michelle de Beer'; mysql list Subject: RE: Select and count duplicates Run this qu

Re: Select and count duplicates

* Michelle de Beer > I have a column containing headlines. In this column > there are some duplicates, like this: > --- > monsters > headline1 > monsters > halloween > monsters > halloween > ... > -- > > How can I get a result like this instead? > HEADLINE | HITS > -

RE: Select and count duplicates

Run this query as rs1: select distinct scary_words from monsters_table; String word; String query; Int count; while rs1.next() { word = rs1.getString(); // Run this sql query as rs2 query = 'select count(*) from monster_table where scary_words="' + word + '"';

re: Select and count duplicates

Michelle, Tuesday, December 03, 2002, 2:27:00 PM, you wrote: MdB> I have a column containing headlines. In this column MdB> there are some duplicates, like this: MdB> --- MdB> monsters MdB> headline1 MdB> monsters MdB> halloween MdB> monsters MdB> halloween MdB> ... MdB> -- MdB> H

RE: Select and count duplicates

SELECT headline, count(*) AS HITS from your_table GROUP BY headline > -Original Message- > From: Michelle de Beer [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 03, 2002 8:27 AM > To: mysql list > Subject: Select and count duplicates > > > I have a column containing headlines. In

Fw: Re: Select and count duplicates

- Original Message - From: <[EMAIL PROTECTED]> To: "DL Neil" <[EMAIL PROTECTED]> Sent: Tuesday, December 03, 2002 1:05 PM Subject: Re: Re: Select and count duplicates > Your message cannot be posted because it appears to be either spam or > simply off topic

RE: Select and count duplicates

Run this query as rs1: select distinct scary_words from monsters_table; String word; String query; Int count; while rs1.next() { word = rs1.getString(); // Run this query as rs2 query = 'select count(*) from monster_table where scary_words="' + word + '"';

RE: Select and count duplicates

select headline, count(*) from headlines_table group by headline; Eva Parackova [EMAIL PROTECTED] -Original Message- From: Michelle de Beer [mailto:[EMAIL PROTECTED]] Sent: 3. decembra 2002 13:27 To: mysql list Subject: Select and count duplicates I have a column containing headlines. I