SQL Query : Joining if null


  • Hi All,

    Question.  I have one table that contains individuals and organisations.  To make things a little easier, I've created two different tables as views; one of individuals with relevant info (uniqueID, name, email), one of organisations (with uniqueID, org name).  I need to join to the organisation view from another table where an organisationID may exist, but not always.  How can I create a valid join between the view and the other table that will still give me the rows where the organisationID is null in the other table?

    Hope that makes sense?! Appreciate any ideas.

    Thanks :-)

    27 มกราคม 2555 1:34