sorry, went to bed
getting a sql error 1064 error in syntax
bastien> Date: Thu, 31 Jan 2008 15:48:02 +1100> From: [EMAIL PROTECTED]> To:
[EMAIL PROTECTED]> CC: php-db@lists.php.net> Subject: Re: [PHP-DB] A little SQL
help> > Bastien Koert wrote:> > Hi All,> > > > Got myself stuck in a little sql
here and can't seem to work out what I am doing wrong> > > > SELECT > >
DISTINCT (tour.record_id), tour.event_start_date, tour.event_end_date,
tour.event_name,CASE WHEN result is NULLTHEN 'N/A'ELSE angler_results.resultEND
CASE > > FROM > > tourLEFT OUTER JOIN angler_results > > ON
angler_results.tour_id = tour.record_idWHERE angler_results.angler_id =1> > > >
where the table TOUR is as above in the primary part of the select and table
ANGLER_RESULTS is (record_id, tour_id, angler_id, result)> > Are you getting an
error?> > Are you getting the wrong results?> > Something else?> > -- >
Postgresql & php tutorials> http://www.designmagick.com/
_________________________________________________________________
