Results 1 to 2 of 2

Thread: Joins

  1. 07-01-2008 #1
    udaykumarn
    udaykumarn is offline
    Junior Member
    Join Date
    Jun 2008
    Answers
    1

    Smile Joins

    Dear Team,
    Cartesian join is not clear to me.Would you pls explain that cartesian product is all combination of rows from different tables.When do we apply cartesian join and where is it useful?

    Reply With Quote Reply With Quote
  2. 07-01-2008 #2
    krishnaindia2007
    krishnaindia2007 is offline
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Re: Joins

    Catersian Product is obtained when you give invalid join condition or ommit join condition. It joins every row of one table with every row of another table. For example if table x with 10 rows joined with table y with 10 rows , a cartesian join will return 100 rows. It is rarely used. Give proper join condition to avoid catesian join.

    Last edited by krishnaindia2007; 07-01-2008 at 10:18 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

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.
GeekInterview
Interact