Results 1 to 6 of 6

Thread: difference between Union All and full outer join

  1. #1
    Expert Member
    Join Date
    Apr 2006
    Answers
    124

    difference between Union All and full outer join

    Hi

    can any one tell me the difference between "union all" and "full outer join"

    thanks in advance


  2. #2
    Expert Member
    Join Date
    Dec 2006
    Answers
    204

    Re: difference between Union All and full outer join

    The output record set in union all contains same number of columns as in the input tables. But it concatenates all the records of both the input tables in the output. Both the input tables should have the same number of columns and same data types for those columns.

    But the full outer join concatenates the columns in both the table. No need for the input tables to have same number of records.


  3. #3
    Expert Member
    Join Date
    Apr 2006
    Answers
    124

    Re: difference between Union All and full outer join

    Hi Barbie

    That was a significant input thank you


  4. #4
    Junior Member
    Join Date
    Dec 2007
    Answers
    2

    Wink Re: difference between Union All and full outer join

    UNION ALL: there is restriction for set operators, i.e. the columns in query 1 must match the columns in query2 in data type,order and number.

    some e.g.:
    display those who are emp as well managers(INTERSECT)
    display those who are not managers (MINUS)
    display those depts which do not have emp(MINUS)
    dispaly those depts which have emp(INTERSECT) try these......


    OUTER-JOIN: used on those tables that keep common columns just like EQUI-JION. but, the o/p will display some extra information which is available in only one of the two tables......

    E.G.:
    display emp details along with coressponding department details and also display that department details which there are no emp....

    than q
    sateesh


  5. #5
    Junior Member
    Join Date
    Oct 2007
    Answers
    1

    Re: difference between Union All and full outer join

    I am taking NT Backup for SAP in SQL Backend. But Backup time is less than one minute and shows the result of backup as OK. Is it correct or wrong .


  6. #6

    Re: difference between Union All and full outer join

    Full Outer join:
    a full outer join combines the results of both left and right outer joins. The joined table will contain all records from both tables, and fill in nulls for missing matches on either side

    example is:
    select * from employee full outer join department on employee.departmentid = department.departmentid;

    Union All:
    The union all operator is used to combine the result-set of two or more select statements and allows duplicate values.

    Example is: select * from employees_norway union all select * from employees_usa;


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact