Re: [SQL] Hi there, having problems with the following:

2001-03-25 Thread Stephan Szabo
You'll probably want something like null::varchar (or other appropriate type) for the nulls. It's trying to grab the type from the first select and can't figure the type out for the null. (Technically speaking, it's probably supposed to be CAST(NULL AS VARCHAR) to be technically sql complient,

[SQL] Hi there, having problems with the following:

2001-03-25 Thread Jens Philipsen
Hi there, having problems with the following: On Postgresql (on Linux) I have 3 tables: 1)employee firstname lastname initials 2)has_title initials title 3)has_trade initials trade Now, what I would like is to get a list of all employees with all their titles and trades - employees can have