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
