On Friday, July 20, 2001, at 08:22 PM, Gary Stainburn wrote:
My view so far is:
CREATE view member_dets as
select *,
getphone(m.mphone) as phone,
getphone(m.mfax) as fax,
getphone(m.mmobile) as mobile,
getunitno(m.mid) as munitno
from members m,
address a,
teams t,
emails e
where m.madd = a.aid
Hi, me again.
I'm having fun here, but here's another question for you.
Could someone please give me an example of a join where one of the fields is
missing - I think reading from the docs that this is an OUTER join, but I'm
having a problem with the syntax. I'm trying to create a view that p
