I'm working on an app utilizing a Sybase db. This is my first time using
Sybase -- having come from a SQLServer and Oracle background, I'm at a loss
as to how to execute a FULL JOIN and and OUTER JOIN.
Any ideas? The following is returning this error:
Error at line 3.
Syntax error near 'a'.
CREATE VIEW VW_RESULTS AS(
select a.last_first, a.company, a.title, a.id as AID
a.member_type, b.activity_type, b.description, c.mailing_lists
from NAME a
FULL JOIN ACTIVITY b
ON a.id = b.id
FULL JOIN LISTS c
ON a.id = c.id
)
thanks,
-e
E. Ellen Grossman
Corporate Web Development
USinternetworking, Inc.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists