Not completely sure what type of result you expect, but here's one that makes
sense to me.
SELECT tour.record_id, tour.event_start_date, tour.event_end_date,
tour.event_name, angler_results.result
FROM tour
LEFT JOIN angler_results
ON angler_results.tour_id = tour.record_id
AND
there is no value from the
angler_results table
Bastien Date: Thu, 31 Jan 2008 10:16:23 +0100 From: [EMAIL PROTECTED] To:
[EMAIL PROTECTED] CC: php-db@lists.php.net Subject: Re: [PHP-DB] A little SQL
help Not completely sure what type of result you expect, but here's one that
makes sense to me
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
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
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