cancel
Showing results for 
Search instead for 
Did you mean: 

oqut table query not retuning results unless all fields have value

neilos
Active Participant
0 Kudos

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

neilos
Active Participant

LEFT OUTER JOIN instead of INNER JOIN!

Accepted Solutions (0)

Answers (0)