select multiple column from multiple table join query [duplicate]

Question

I have Table A,Table B,Table C,Table D,Table E

Table A columns are a1,a2,a3
Table B column are a1,b1
Table C column are b1,c1
Table d column are a1,d1
Table e column are d1,e1,e2,e3,e4,e5,e6,e7

NOTE:

I will enter the a1 so I want all a1 related data from the database. where a1 is relate to table b and table d ,b1 is relate to table c,d1 is relate to table e and I also want table e data.

means i want d1,e1,e2,e3,e4,e5,e6,e7,b1,c1 at same time when I enter a1

Why do people think that obfuscating table and column names make things easier. Also which DBMS are you using? Oracle? Postgres? — user330315
– user330315, Commented Jun 26, 2014 at 7:40
Looks like some straight forward joins. Could you please share what you have tried and where you struggle? — Peter Lang
– Peter Lang, Commented Jun 26, 2014 at 7:41

Elliott Frisch · Accepted Answer · 2014-06-26 07:43:32Z

0

If I understand your question, then you can do a cross-join on the tables. You want something like this,

SELECT d1,e1,e2,e3,e4,e5,e6,e7,b1,c1 FROM
    A, B, C, D, E
WHERE
  A.a1 = B.a1 AND B.a1 = D.a1 AND B.b1 = C.b1 AND D.d1 = E.d1

answered Jun 26, 2014 at 7:43

Elliott Frisch

202k20 gold badges166 silver badges265 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sid M · Accepted Answer · 2014-06-26 07:55:01Z

0

select 
   E.d1,E.e1,E.e2,E.e3,E.e4,E.e5,E.e6,E.e7,B.b1,C.c1 
   from A,B,C,D,E 
   where A.a1 = B.a1 
      and B.a1 = D.a1 
      and B.b1 = C.b1 
      and D.d1 = E.d1

answered Jun 26, 2014 at 7:55

Sid M

4,3744 gold badges33 silver badges51 bronze badges

Collectives™ on Stack Overflow

select multiple column from multiple table join query [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related