At 11:53 AM 18/03/2003 +0000, you wrote:

> >
> > select t2.MyField1, t1.*
> > from table1 t1
> > outer join table2 t2
> > on t1.MyField1 = t2.MyField1
> > where t2.MyField1 is null
> >
>
>
>This gives me:
>
>Invalid token.
>Dynamic SQL Error.
>SQL error code = -104.
>Token unknown - line 5, char 1.
>outer.

sorry, replace outer with left. :(

helen

>Michael
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/