Solved Query output using multiple tables (1 Viewer)

[nirmal]

How to get a query output in access query with multiple table joined, if some field in one table is null.
If all table values are there then I get the result.
But if one value in some table is null the I dont get the output.
Please help me to solve this issue.

 

[CarlettoFed]

If you don't attach a sample file it's not possible to do it in your imagination.

 

[ebs17]

A query has no problems with the output of NULL contents in fields.
However, one has to consider some peculiarities when performing comparative operations like JOIN or WHERE with such NULL contents:

Modern SQL: Three-Valued Logic (3VL) — Purpose, Benefits and Special Cases

Making decision despite missing SQL data (NULL): How to avoid OR…IS NULL in the WHERE clause.

modern-sql.com

 

[nirmal]

Sir I am attachig the database.
Here when I open the sample report which is query based, if all fieds are not null, then I get the valuesin the report.
If some cell value is null or empty, then the report values are blank.
So here I want to still have the report values, even if some cell values are null.

 

[ebs17]

1) I find it an imposition when such examples do not include a relationship picture and therefore one have to guess about relationships between tables or do extensive research. This costs my time unnecessarily. If you want to waste time, please waste yours, not mine.

2) If necessary, use an OUTER JOIN instead of an INNER JOIN for links between tables. I show this as an example for two tables:

SELECT
   Profile_tbl.*,
   Marital_tbl.MaritalStatus
FROM
   Profile_tbl
      LEFT JOIN Marital_tbl
      ON Profile_tbl.MaritalID_FK = Marital_tbl.MaritalID

So deal with link types.

 

[nirmal]

Thank You Sir.
It works accurately.