I'm missing outer joins

Поиск
Список
Период
Сортировка
От bill@wadley.org
Тема I'm missing outer joins
Дата
Msg-id Pine.LNX.4.21.0006011447200.13448-100000@wadley.org
обсуждение исходный текст
Список pgsql-sql
Hello!

Well, I have a need for an OUTER JOIN, but have semi-solved it by using
a UNION. However, I can't do an ORDER BY on a UNION, and have since
discovered that a VIEW can not be used with a UNION.

Is there another way (possibly with one or more FUNCTIONs), for me to get
this join on two tables (where one table may have no matching rows) via a
single sorted query?

Thanks!

Bill



В списке pgsql-sql по дате отправления:

Предыдущее
От: mikeo
Дата:
Сообщение: short query becomes long
Следующее
От: p.lam@altavista.net
Дата:
Сообщение: Simulating CURSORS??