Re: Need help with OUTER JOIN...SOLVED

On 11/18/2011 12:15 PM, Richard Broersma wrote:
> On Fri, Nov 18, 2011 at 9:44 AM, Matt Foster<Matthew(dot)Foster(at)noaa(dot)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';
>
>
>

Hey...that works! Thank you, Richard!

--
Do not go where the path may lead; go instead where there is no path and leave a trail.
-- Ralph Waldo Emerson