Results 1 to 3 of 3

Thread: Join Two Tables without Common Column

  1. #1
    Junior Member
    Join Date
    Jun 2009
    Answers
    1

    Join Two Tables without Common Column

    How to join the data of two tables which does not have common columns but can be done by using two others tables but How?

    I have four tables and wants to extract data only from two tables but they do not have any common column so i have to use other two also because three tables are having the common columns.

    Can you please provide the technical details of this its very urgent Please...


  2. #2
    Contributing Member
    Join Date
    Jun 2009
    Answers
    76

    Re: Join Two Tables without Common Column

    Join the tables with common columns with those do not have . E.g. t1 and t2 do not have common columns but t3 and t4 have common columns eachother and with the t1 and t2 . Then just join with t3 with t1 and t4 with t2 and then t3 and t4 , but select the columns from t1 and t2. I hope this might help if i have correctly understood your question. Thanks


  3. #3
    Contributing Member
    Join Date
    May 2009
    Answers
    49

    Arrow Re: Join Two Tables without Common Column

    Quote Originally Posted by ashutosh4567 View Post
    How to join the data of two tables which does not have common columns but can be done by using two others tables but How?

    I have four tables and wants to extract data only from two tables but they do not have any common column so i have to use other two also because three tables are having the common columns.

    Can you please provide the technical details of this its very urgent Please...
    Now you have 4 tables T1, T2, T3, T4. You want to extract data from T2 and T3 which do not have a common column. But say both T2 and T3 have common columns with T1 and T4. In this case you need to use the common columns only in the join condition, but you are not retrieving any data from T1 and T4.

    Tell me if this resolves ur issue or that if you need further assistance.


  4.  Sponsored Ads
    Ad


     

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