<[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Group Query
Date: Tue, 22 Jun 2004 10:56:12 +0200
Shaun,
when you add "WHERE B.Project_ID > = '10'" you, in a way,
change your LEFT JOIN to an INNER JOIN.
You need to do it like:
LEFT OUTER JOI
P
BY(U.User_Location);
Any ideas, do I need to do a double join, or do I need to join the
projects table also?
Thanks for your help
From: "Paul McNeil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: Group Query
Date: Fri, 18 Jun 2004 08:20:10 -0400
You can use a Left
ct_ID = '8' GROUP
BY(U.User_Location);
Any ideas, do I need to do a double join, or do I need to join the projects
table also?
Thanks for your help
From: "Paul McNeil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: Group Query
Date: Fri, 18 Jun 2004 08
You can use a Left Outer Join. Left Outer Join will include all that
matches as well as that which doesn't. The resulting NULL entries for the
count will evaluate to 0.
SELECT COUNT(B.Booking_ID), U.User_Location FROM
Users U
LEFT OUTER JOIN
Bookings B
ON
U.User_ID = B.User_ID GROUP BY(U.User_Lo
Hi,
you can use:
SELECT COUNT(B.Booking_ID), User_Location
FROM Users U
LEFT JOIN Bookings B ON U.User_ID = B.User_ID
GROUP BY(U.User_Location);
/Johan
shaun thornburgh wrote:
Hi,
The following table produces a query that shows all bookings that user
has made and groups the number of bookings by t
