RE: [PHP] URGENT - Help in mySql query

But this won't serve my purpose as for me the count of first table is important. For example,

 newsletter     newsletterArticle
        1        2 articles

        2        3 articles

        3        1 articles

        4        no articles

Then the query SELECT * FROM newsletter, newsletterArticle WHERE newsletter.ID = newsletterArticle.refID; will return me record count as 6 where as I want it as 3 (i.e. master table count). That's why this query won't give me the required results. Any other solution ? (like distinct / exists ? ) manisha At 12:34 PM 10/18/01 +1000, Jason Murray wrote:

Pretty simple really: SELECT * FROM newsletter, newsletterArticle WHERE newsletter.ID = newsletterArticle.refID; ... will only pull out data when the condition is satisfied. Jason -- Jason Murray jasonm@melbourneit.com.au Web Developer, Melbourne IT "Work now, freak later!" -----Original Message----- From: Manisha [mailto:manisha@aurica.com] Sent: Thursday, October 18, 2001 12:29 PM To: php-general@lists.php.net Subject: [PHP] URGENT - Help in mySql query hi, I want to write one query. I have 2 tables one as a master and another as detail. 1) newsletter - master table - ID and title is stored 2) newsletterArticle - details table - artID, refID (ref of master table) and body text is stored. I want to display the newsletter only if I found corresponding record in newsletterArticle. i.e if in newsletter there is an entry for ID 1, but no article in newsletterArticle, then I do not want to display that record. This I want to achieve in single query. Something like below select ID from newsletter where (select count(*) from newsletterArticle where refID = the ID of newsletter ???? > 0) Platform - PHP / mySql /BSDi Any help ? It is very urgent manisha -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net