second statement.
Rhino
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Dean Karres" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, October 05, 2004 9:26 AM
Subject: Re: counting records and JOINS
> I think you are on the right track
I think you are on the right track. All you need to make your new
statement work is a GROUP BY clause. You can either reference your columns
by name or by position.
SELECT P.id,
P.date,
D.browser_decoration,
PD.entry_date
COUNT(PD.*)
FROM Process P
LEFT JOIN
Hi,
I have a process that relies on three tables. There is a "Process"
table, a Process_description table and a third table that holds some
display decoration hints that depend on the perceived nature of each
process.
The decoration table is static. It looks like
decoration
{
severity_level