sql - select multiple column from multiple table join query -

this question has answer here:

i have table a,table b,table c,table d,table e

table columns a1,a2,a3 table b column a1,b1 table c column b1,c1 table d column a1,d1 table e column d1,e1,e2,e3,e4,e5,e6,e7

note:

i enter a1 want a1 related data database. a1 relate table b , table d ,b1 relate table c,d1 relate table e , want table e data.

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

if understand question, can cross-join on tables. want this,

select d1,e1,e2,e3,e4,e5,e6,e7,b1,c1     a, b, c, d, e   a.a1 = b.a1 , b.a1 = d.a1 , b.b1 = c.b1 , d.d1 = e.d1

CSS