Query to display Count as zero if no records exists - Urgent please

Count should be displayed as zero if there is are no recipes posted

select f.dishes,f.contentid,f.titleurl,count(f.dishes) as Recipescount from food f inner join foodmemberpref fmp
on f.contentid=fmp.foodid where isapproved=1 and blogcid>0
and f.contentid in(1,30,68,73,83)
group by f.dishes, f.contentid,f.titleurl

When I execute the above query I get the result displayed as given below

Dishname Contentid Titleurl Recipescnt
Aloo Chat 1 punjabi/aloo-chat 1
Payasam 30 south-indian/payasam 5
Aloo Tikki 68 punjabi/aloo-tikki 7

I want the Output to be displayed as. I want to display even those dishes count for which the count is zero, in other words it should display the count of all dishes even if it is zero

Dishname Contentid Titleurl Recipescnt
Aloo Chat 1 punjabi/aloo-chat 1
Payasam 30 south-indian/payasam 5
Aloo Tikki 68 punjabi/aloo-tikki 7
Carrot Kheer 73 north-indian/carrot-kheer 0
Coconut Rice 83 south-indian/coconut-rice 0

Sep 23 '08 #1

Subscribe Post Reply

3973

ck9663

2,878

Expert 2GB

Use LEFT JOIN instead of INNER.

-- CK

Sep 23 '08 #2

Similar topics

MySQL/PHP - Query Form

by: Mike Cocker | last post by:

Hello, I'm quite weak at PHP, so I was hoping to get some help understanding the below code. First off, I'm trying to create a "query form" that will allow me to display the results on my...

PHP

query to check if a certain value does exist in a field

by: | last post by:

If I need to check if a certain value does exist in a field, and return either "yes" or "not" which query would be the most effestive?

ASP / Active Server Pages

please help with mysql query string

by: Ljoha | last post by:

I need to create report where will be shown total quantity of all rows for every hour in some data range. I have a table where I have column in DATETIME format. I have problem to create sql...

MySQL Database

query using dates

by: C White | last post by:

Hi I am having problems with running a query that does the following there are 5 fields in a table that the query is based on, the first four are simple enough and all that happens is that the...

Microsoft Access / VBA

slow query

by: Andy_Khosravi | last post by:

My problem: I'm having trouble with a query taking much too long to run; a query without any criteria evaluating only 650 records takes over 300 seconds to run (over the network. On local drive...

Microsoft Access / VBA

query with no records...

by: NewUser | last post by:

I try this: A first "group" query (sorry if this isn't the right name) count the records from a table with a criteria (field1="A") and return counter1=10 records. A second "group" query count the...

Microsoft Access / VBA

help with a query

by: Sam | last post by:

Hi, I have one table like : MyTable {field1, field2, startdate, enddate} I want to have the count of field1 between startdate and enddate, and the count of field2 where field2 = 1 between...

Microsoft SQL Server

Display DISTINCT Count on Report Header

by: AccessHunter | last post by:

Hi, Please help with this problem. I have a report that displays a list of Case/Judge Records. using the following fields, Case Nbr, Case Seq Nbr, Judge Name, Attorney name 723187, 1...

Microsoft Access / VBA

Sub Query for fetching records - Urgent Please

by: padmaneha | last post by:

I executed the below query for getting the details of dishes which are tagged to the festival 'Durga Pooja' select fg.tagname, fg.foodid, f.dishes, f.dishtype from foodtag fg inner join food f ...

Microsoft SQL Server

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA