Well there are a million ways to SQL a cat. Here is one:
SELECT Q.authorID, A.authorFirstName, A.authorSurname, A.articleAuthenticated
FROM
(
SELECT authorID FROM tbl_020articleDetails
WHERE articleAuthenticated = 1
GROUP BY authorID
) Q INNER JOIN tbl_020authorDetails A ON Q.authorID =
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
I've got a query whereby I am getting a list of all authors (table:
tbl_020authorDetails) in my database. I am cross referencing against
all the articles (tbl_020articleDetails) and only displaying
the authors
who have an article published
Hi, I'm getting an error with both your reply and Michaels so I don't know
if it's something I explained incorrectly.
I'm getting this error:
http://www.020.com/webs/020/content.cfm?writers
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name
'articleAuthenticated'.
I do however
Just do a SELECT DISTINCT...
-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Monday, December 06, 2004 4:16 PM
To: CF-Talk
Subject: Re: Joins
Hi, I'm getting an error with both your reply and Michaels so I don't
know
if it's something I explained incorrectly.
I'm
4:16 PM
To: CF-Talk
Subject: Re: Joins
Hi, I'm getting an error with both your reply and Michaels so I don't
know
if it's something I explained incorrectly.
I'm getting this error:
http://www.020.com/webs/020/content.cfm?writers
[Macromedia][SQLServer JDBC Driver][SQLServer
5 matches
Mail list logo