Potentially all of them...except fields that contain 'date entered', 'modified by', 'created by' etc....

I'm not sure what your query is...are you replacing all of the left joins or are you just replacing the final WHERE clause so that it looks like:

SELECT SQ.*, DEdescription,...

Remi,

Ok, I looked up Isnull and I don't see how it will help with my query.

It seems like I was on the right track with my original query. 

Remi,

Is that a built-in sql server function?  I'll have to do some research on it.

Thanks,

M

But doesn't the ISNULL function just replace the specified ID with a zero if it is NULL?  What would this do?

Sorry to sound ignorant.

Thanks,

M

Remi,

I'm sorry, but I totally cannot comprehend this: where "wanted id" in (isnull(colid1,0), isnull(colid2,0), isnull(colid3,0)).

I've never done a query that looks even remotely like that.

So do you think I can't...

The data can be modified by the students.  When I do the select statement...if I ever get it working, I am going to populate a form with the returned data.

Thanks,

M

In the script, all the schoolrequests(SLid) are listed out in tabular format.   A student can click on the SLid that he/she wants and that will open up a new window...

The problem is, I can't get all of that information assembled correctly.  Right now, I've gotten it to the point where I can gather all the data except the diaryentry...

Here is one row from the schoolrequest table with corresponding rows from the diaryentry and academicoffice tables. Keep in mind that there can be multiple diary entries with the same...

Replacing the INNER JOINS with LEFT JOINS gave me all the data I need EXCEPT the diary data....

Does that replace empty records with '0'  ?

Or maybe I want to LEFT JOIN all of the columns instead of INNER JOIN??

Remi,

The only thing I'm trying to filter out is when DEdeletedDate is not null(signalling that it was deleted).

The query is supposed to get all the data for a specific SLid. 

BTW the SLid=DEkeyValue...

Thanks for your quick reply Remi.  I hope you make a great deal of money dealing with SQL because you deserve it.

Anyway, I tried your modified query and noticed something...