-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
you're sure this command resulted not in an error. As far as I understand the
documentation the VIEW keyword is mandatory when creating a view. So this
should be:
> CREATE VIEW qry_contacts AS
^^^^
> SELECT c.contact_id, c.firstname, c.lastname,
> (CASE
> WHEN
> (c.firstname & c.lastname) ISNULL
> THEN
> 'unnamed'
> ELSE
> (c.firstname & ' ' & c.lastname)
> END) AS fullname,
> ct.contacttype
> FROM contacts c LEFT JOIN contacttypes ct ON
> c.contact_id = ct.contact_id;
Just a first guess of an other newbie...
Greets,
Andre
- --
Andre Vehreschild -- Institute for Scientific Computing, RWTH Aachen Univ.
mailto:[EMAIL PROTECTED] , phone: ++49- 241- 80- 24874
GnuPG-key available at http://www.sc.rwth-aachen.de/vehreschild
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
iD8DBQFAWHJ8zVF62HujQtARAo8RAJ9siHv0Plf5lTwaZxi7IZQ9Ef3MtQCfaX8E
W/HO6ZtyEGx0TS8XaAgKmDU=
=1FCA
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
