Re: Need help with OUTER JOIN

On Fri, Nov 18, 2011 at 9:44 AM, Matt Foster <Matthew.Foster@noaa.gov> wrote:

> SELECT office_list.office, verification_data.period
> FROM office_list
> LEFT OUTER JOIN verification_data USING (office)
> WHERE start_time > 'yesterday'
> AND start_time < 'today'
> AND period=1
> AND name='foo'
> AND element='bar';


1) Replace the USING() to ON office_list.office = verification_date.office

Find all of the columns in your WHERE clause that are in your
Verification_Data table and move these criteria to ON clause.

SELECT office_list.office, verification_data.period
FROM office_list
LEFT OUTER JOIN verification_data
ON Office_list.office = verification_data.office
AND start_time > 'yesterday'
AND start_time < 'today'
WHERE period=1
AND name='foo'
AND element='bar';



--
Regards,
Richard Broersma Jr.