Ed Since schrieb:
> Hello, I'm wondering if this is the most effective way of doing an outer
> join with 'extra criteria' (I don't feel like it's the best way):
>
> SELECT e.EventID, ue.Contact, ut.Discount
> FROM Event e
> LEFT OUTER JOIN
> (SELECT EventID, Contact FROM UserEvent WHERE UserId =
Hello, I'm wondering if this is the most effective way of doing an
outer join with 'extra criteria' (I don't feel like it's the best way):
SELECT e.EventID, ue.Contact, ut.Discount
FROM Event e
LEFT OUTER JOIN
(SELECT EventID, Contact FROM UserEvent WHERE UserId = 10) ue
using (EventID)
LE