hi experts,
here is my view
SELECT
dbo.orcCHAMBRES.NUMCHB,
dbo.orcCHAMBRES.TYPCHB,
dbo.orcCHAMBRES.ETATCHAMB,
dbo.orcPLANNING.DATEARRIV,
dbo.orcPLANNING.NBADULTES,
dbo.orcPLANNING.NOMCLI,
dbo.orcPLANNING.NUMSEJOUR,
dbo.orcSEJOURS.COMMENT,
dbo.orcSEJOURS.MEMO,
max( dbo.orcSEJOURS.DATEDEPART) AS max_planning_date
FROM
dbo.orcCHAMBRES
LEFT OUTER JOIN dbo.orcPLANNING ON (dbo.orcCHAMBRES.NUMCHB = dbo.orcPLANNING.NUMCHB)
LEFT OUTER JOIN dbo.orcSEJOURS ON (dbo.orcPLANNING.NUMSEJOUR = dbo.orcSEJOURS.NUMSEJOUR)
WHERE
dbo.orcPLANNING.DATEARRIV LIKE '20110715' AND
dbo.orcCHAMBRES.TYPCHB NOT LIKE 'SALO'
GROUP BY
dbo.orcCHAMBRES.NUMCHB,
dbo.orcCHAMBRES.TYPCHB,
dbo.orcCHAMBRES.ETATCHAMB,
dbo.orcPLANNING.DATEARRIV,
dbo.orcPLANNING.NBADULTES,
dbo.orcPLANNING.NOMCLI,
dbo.orcPLANNING.NUMSEJOUR,
dbo.orcSEJOURS.COMMENT,
dbo.orcSEJOURS.MEMO,
dbo.orcSEJOURS.DATEDEPART
ORDER BY
dbo.orcCHAMBRES.NUMCHB
I need it to be modified in order to show all the records from dbo.orcCHAMBRES even if other tqbles have no values
thank
WHERE (dbo.orcPLANNING.DATEARRIV
dbo.orcCHAMBRES.TYPCHB NOT LIKE 'SALO'