I've read this many many times. But, it won't work for me. We need all the data

from 'ClaimsTable' table regardless if we find a value in the lookup table...

So, what's your solusion? INNER JOIN? and what are they?

Thanks,

Chandi

Yes, we need all the joins. We look up Organization, Units(1 and 2) ,  Month and Year, 'Level Of Care', providers by postal codes and Units, Services by service code, Clients...

Here is the view and the index script. Most of the joins are lookup values, ie for '01' we want to display 'Jan' in the view.

/*  The View  */

CREATE VIEW...

Well, I can certainly try that, but it wouldn't make a difference for us. Users access this view through MS Access as an 'ODBC' import table, and it times...