0

How would you manipulate a query so that the rows with null values in a table resulting from a full outer join do not show up in the result?

The Bear
  • 199
  • 2
  • 8

1 Answers1

1

WHERE value IS NOT NULL

You can find a full explanation here:

http://www.w3schools.com/sql/sql_null_values.asp

PitterPatter
  • 63
  • 5
  • Not Sure if this answers my question because I don't think this applies to full outer joins – The Bear Mar 08 '14 at 02:52
  • 1
    Make sure your WHERE filter is after your ON selection. – PitterPatter Mar 08 '14 at 02:58
  • There is [no such thing as "Postgre"](http://wiki.postgresql.org/wiki/Identity_Guidelines). And you should link to the [current version of the manual](http://meta.stackexchange.com/questions/108714/best-way-to-reference-the-postgresql-manual). Please fix your answer, and [look into formatting aids while being at it.](http://stackoverflow.com/editing-help) – Erwin Brandstetter Mar 08 '14 at 03:35
  • Yea, sorry. On my phone from the road. Maybe someday I'll be a pro at stackoverflow... – PitterPatter Mar 08 '14 at 05:28