Best way to lookup

Results 1 to 2 of 2

Thread: Best way to lookup

  1. #1
    Join Date
    Dec 1969

    Default Best way to lookup

    hi all, <BR> I have got some 10 codes and for which i have to show the descriptions on the screen from 10 lookup tables.till now i am using a join to query all those 10 lookup tables at a time and it is working fine.but the problem is, if a single code is not found in any of the lookup tables, the query is returning me an empty recordset(for obvious reasons).Pls dont&#039; ask me why you have a code which is not existing in the lookup.we have some inconsistent for this inconsistent data, i want to show a blank/"--". <BR>so please help me out in solving this problem. <BR>what is the best way to query with the above said problem of missing codes in lookup tables. <BR>Thanking you all

  2. #2
    Join Date
    Dec 1969

    Default RE: Best way to lookup

    I think you could just change yur join to "LEFT JOIN"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts