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
 
 
 
_________________________________________________________________

Reply via email to