Interested to Buy Any Domain ? << Click Here >> for more details...
Select * from emp,dept,loc where emp.deptno left outer join
dept.deptno and dept.locno=loc.locno.
No need to consider the syntax but is it possible to have
left outer join and equi join in the same SQL like this ?
can we have right outer join and left outer join in the
same SQL ---
- 1 Answers
- 7815 Views
- Principal Finance, PT Metalogix Infolink Persada, I also Faced
- E-Mail Answers
Answer / mayur
You can very well put Inner / Left Outer / Right Outer join
in the same SQL Query.
| Is This Answer Correct ? | 14 Yes | 0 No |
What are universe requirements?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What are the different types of datawarehosuing?
What are the steps involved in designing a fact table?
What is the difference between view filter and report filter?
How do you setup Lo-cockpit?
What is dimension modeling?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
Why denormalization is promoted in universe designing?
What is Cognos script editor?
What is perform recovery?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Teradata 
