Re: SQL design/query question

2002-07-03 Thread Chris Griffin
late, I've not tested this code, and this is free > advice, > take it for what it's worth.) :) > > HTH, > =C+ > * > * Cal Evans > * The Virtual CIO > * http://www.calevans.com > * > > > -Original Message- > From: Chris Griffin [mailto:[EMAIL

RE: SQL design/query question

2002-07-02 Thread Cal Evans
The Virtual CIO * http://www.calevans.com * -Original Message- From: Chris Griffin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 9:08 PM To: [EMAIL PROTECTED] Subject: SQL design/query question If this is not the right list for this please direct me to the proper list. I have

Re: SQL design/query question

2002-07-02 Thread Jed Verity
You need a LEFT JOIN. Read about it here: http://www.w3schools.com/sql/sql_join.asp Go down to the "LEFT JOIN" section. HTH, Jed I liked it when Chris Griffin wrote this to me: > If this is not the right list for this please direct me to the proper > list. > > I have a table of name/address

SQL design/query question

2002-07-02 Thread Chris Griffin
If this is not the right list for this please direct me to the proper list. I have a table of name/address information. I need to keep track of a weekly event and if they participated or not. I thought I could have a table of dates and people record ids with just those that participated. The