6 Replies Latest reply: Mar 3, 2011 11:27 AM by Goran Korsgren RSS

    How to filter out NULL value records

      HI all,

      Perhaps this question sounds like simple, but I am not able to figure this out.

      I have 2 tables:

      Table A - have report details with the owner user ID

      Table B - Active User information

      So, table A owner ID should be link up with Table B. But some records may not able to find a value in B since the user left the firm already. Thus, I would like to take out all the records that do not have a matched receord in B using JOIN.

      How can I do so?

      I tried to use INNER JOIN / LEFT JOIN but this does not work.

      I also tried to create a TEMP table first with the JOIN and LOAD another table using the RESIDENT TEMP table where NOT isnull(UserName), also does not work.

      Thanks all