Sampson, Peter wrote:
> Gabriel.
>
> This works fine and the two tables talk to each other.
>
> BUT,
> My website can have 5 - 10 news stories per month. So in the tblNews I
> could have
>
[Snip multiple rows]
> I need to use DISTINCT in the SQL lingo as I "bind" the recordset's
> "nMonth"
+
-Original Message-
From: Peter Sampson [mailto:[EMAIL PROTECTED]]
Sent: 16 May 2002 06:58
To: Sampson, Peter
Subject: Fw: Fw: Simple SQL
- Original Message -
From: Gabriel <>
To: Peter Sampson <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wed
-Original Message-
From: Sampson, Peter
Sent: 16 May 2002 09:35
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: FW: Simple SQL
Roger et al. Thanks for your response in reference to MySQL Query
I'm interested to find out more on how to do the fo
This was addressed privately, but that's not a big deal. :) (I forgot
to hit reply-all. :P)
Peter Sampson wrote:
> So i change the properties of Month to Integer in tblNews?
Say you have two tables:
mysql> show tables;
++
| Tables_in_test |
++
| MonthNames
So i change the properties of Month to Integer in tblNews?
Create another table called MonthNames? Now I'm lost a bit, please can you
clarify?
I can populate the MonthNames table with jan feb march etc
Please can you clarify the next bit, I not familar with n JOIN ON n
Month?
>
