On Sat, Nov 22, 2014 at 8:03 PM, Roj Beraña <[email protected]> wrote:
> Will it be able to create a sql script like this? > > SELECT * FROM Employee e > LEFT OUTER JOIN Thing t on e.Id = t.EmployeedId AND t.Name = "A" > LEFT OUTER JOIN Thing t on e.Id = t.EmployeedId AND t.Name = "B" > > Does this query run without error if run directly, the "t" alias is repeated, how is this different from say SELECT * FROM Employee LEFT OUTER JOIN Thing t on e.Id = t.EmployeedId AND (t.Name = "A" OR t.Name = "B") -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
