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
- 7721 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 is a data profile?
What is crass reference table?
Give me a broad concept of what a data warehouse is, and what it might be used for?
What is conformed dimension?
what is the difference between MOLAP and ROLAP?
Can we have more than one time dimensions in a Schema(Star or Snowflake)
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
Can we start and stop single session in concurent bstch?
What is the very basic difference between data warehouse and operational databases?
Which are the olap tools available that are supported by oracle?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Teradata 
