on 02-08-2021 8:48 AM
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
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.