Skip to Content
0
Feb 08, 2021 at 08:48 AM

oqut table query not retuning results unless all fields have value

23 Views

Hi all,

I have a query that is only returning rows where values exist.

SELECT T0.[DocNum], T0.[DocDate], T0.[NumAtCard], T1.[PrjName], T0.[SlpCode] FROM OQUT T0  INNER JOIN OPRJ T1 ON T0.[Project] = T1.[PrjCode] WHERE T0.[DocStatus] = 'o'
The T1.[PrjName] is needed, but this query is only returning results where it has a value, if it is empty then it doesn't return anything instead of leaving it blank.

How can I rewrite this to show records including the empty T1.[projName] ?

Thanks