Re: Joins

2004-12-06 Thread Adrocknaphobia
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 =

RE: Joins

2004-12-06 Thread Michael T. Tangorre
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

Re: Joins

2004-12-06 Thread Stuart Kidd
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

RE: Joins

2004-12-06 Thread Bryan Love
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

Re: Joins

2004-12-06 Thread Stuart Kidd
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