I have done a table join as follows
select * from Table1 left outer join Table2 on Table1.field1 + Table2.field1
where table2.fieldx ='xxx'

The query cannot do the where when it refers to a field from the joined
table.

Is there a way to refer to a field on  the joined table in the where clause
that I don't know about?

Thankyou
Jenny

Change the "Where" to "AND"

example
Select
        *
FROM
        BillTmp4
LEFT OUTER JOIN V_Case_Status vcs2
        On Billtmp4.case_status_id = vcs2.case_status_id
        and  Billtmp4.case_status_id = 7

In the ON clause, you need to compare the columns from the two tables,
not add them together.

  SELECT *
  FROM Table1
    LEFT OUTER JOIN Table2
      ON (Table1.field1 = Table2.field1)
  WHERE table2.fieldx = 'xxx'

What database back-end are you using? That would be valid SQL in local
SQL. When does the error occur?

Do you also have persistent field objects defined for the columns
returned by this query? If so, could one of these defined field object
no longer be valid and now causing an error regarding a field that
cannot be found?

===========================================================
Steve Koterski
Technical Publications
Borland