Hi..

I have fields in two different tables.  One contains data.  One does not.  The deciding factor on which field contains data is based on what type of order it is.  The two fields never both contain data.  How can I write a formula to pull in the field containing data?

You could do something like this:

select
case where table1.field is null then table2.field else table1.field end as field
from
table1 inner join table2 on table1.key = table2.key