A little SQL help
| From: | Bastien Koert | Date: | Thu, 31 Jan 2008 03:47:18 +0000 |
| Subject: | A little SQL help | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44543@lists.php.net to get a copy of this message | ||
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)
Any ideas?
Bastien
_________________________________________________________________