Subject | Re: [IBO] Ambiguous fieldname between ... |
---|---|
Author | lester@lsces.co.uk |
Post date | 2002-01-02T09:16:27Z |
> SELECT m.*What is the join for ?
> from member m
> join memberinfund f
> on m.memberid=f.memberid
> for update
While the m.* should only return the fields in m, the join
is probably trying to do something, I would tend to list all
the fields so that you can eliminate those you do not need,
and correctly identify the m. and f. entries.
You don't say which version of IB/FB, and I would assume the
latest FB from the error - so it is WARNING that it can't
specifically identify a field.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services