Обсуждение: SQL query question

Поиск
Список
Период
Сортировка

SQL query question

От
"news1.on.sympatico.ca"
Дата:
I've been having problems with this query.  The second sub-query will not
always return data.
When that is the case, main query will not return a value, even though the
first query does.
Would anyone have any suggestions as to how I could return the
events.EventCost even if
registration.registrationRegCost is null?

SELECT (events.EventCost + registration.registrationRegCost) AS subtotal
FROM (SELECT [Event Registration].RegID AS eventRegID,
              SUM(Events.EventCost) AS EventCost
              FROM Events INNER JOIN
              [Event Registration] ON
              Events.ID = [Event Registration].EventID
              WHERE [Event Registration].RegID = 399
              GROUP BY [Event Registration].RegID) AS events,

            (SELECT dbo.[Registration Information].RegID AS
registrationRegID,
            dbo.[Registration Types].RegCosts AS registrationRegCost
            FROM dbo.[Registration Information],
            dbo.[Registration Types]
             WHERE dbo.[Registration Information].RegType =
dbo.[Registration Types].RegTypeID
            AND dbo.[Registration Information].RegID = @regid2) AS
registration