"DL Neil" <[EMAIL PROTECTED]> on 12/06/2001 05:27:55 PM
Internet mail from:
Please respond to "DL Neil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
cc: <[EMAIL PROTECTED]>
Subject: Re: select statement group by unusual results
Hi Chip,
Hi Chip,
> Thanks for the tips. So here's my latest attemp:
>
> select distinct Title, Details, StartDate, StopDate, City, State
> from phpCalendar_Details t1, phpCalendar_Daily t2, phpCalendar_EventLocations t3
> where t1.LocationID = t2.LocationID
> and t1.EventLocationID = t3.EventLocationID
>
"DL Neil" <[EMAIL PROTECTED]> on 12/06/2001 12:26:45 AM
Internet mail from:
Please respond to "DL Neil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
cc: <[EMAIL PROTECTED]>
Subject: Re: select statement group by unusual results
Chip,
> &
Chip,
> > I have a database with 12 tables. I am running a query to select certain
> > fields
> > from 3 of the tables, like this -
> >
> > select Title, Details, StartDate, City, State
> > from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations
> > where phpCalendar_Details.Event
"DL Neil" <[EMAIL PROTECTED]> on 12/05/2001 11:35:46 PM
Internet mail from:
Please respond to "DL Neil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
cc:
Subject: Re: select statement group by unusual results
Chip,
> I
Chip,
> I have a database with 12 tables. I am running a query to select certain
> fields
> from 3 of the tables, like this -
>
> select Title, Details, StartDate, City, State
> from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations
> where phpCalendar_Details.EventLocationID =
I have a database with 12 tables. I am running a query to select certain
fields
from 3 of the tables, like this -
select Title, Details, StartDate, City, State
from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations
where phpCalendar_Details.EventLocationID = phpCalendar_EventLoca
