CODEWITHSUNDEEP
sql-server-2008joinconditional-statements
Vyasdev Meledath
Vyasdev Meledath

Reputation: 9016

Condition joining in SQL Server 2008

I want to dynamically join 2 tables in SQL Server that means according to table value count, as LEFT join or RIGHT join.. Is it possible in SQL Server ? If yes please explain

Thanks in advance

Upvotes: 1

Views: 284

Answers (1)

Sir Crispalot
Sir Crispalot

Reputation: 4844

I don't believe it is possible to conditionally do a left join or right join.

However, as both of these joins are essentially a filtered full outer join, could you use that and then use where clauses to get what you want?

However this seems less than ideal, and I would question why you need to do this in the first place.

Upvotes: 2

Related Questions