|
Anouar
Starting Member
Denmark
8 Posts |
 Posted - 02/15/2013 : 09:13:09
|
Im using 2 tables, with the following query:
SELECT Lånernr, Lånernavn, SUBSTRING(CPRNummer, 0, 7) AS Fødselsdag, Allotment
FROM tblLånere
INNER JOIN eaAllotments ON eaAllotments.Lånernummer = tblLånere.LånerNr
WHERE EksamensAnsvarlig = 1 AND Period_id = 17
The issue is that the table allotments not always have a record for a user (låner). I would like to have a null value or something.
Best Regards
Anouar |
|
When No Row Exists Return Value
