Query in Access DataBase

Question

User2081941926 posted

Hi to all Friends..

  am using Access DataBase. I want one query  from two tables i.e

tbl 1

Risk	Function1	Function2	Function3	Function4	Function5	Function6	Function7	Function8

 tbl2

Function	Language	Function Description

required query is

Risk	Function	Function Description

can any one help me in this ......

Thanks

Adisheshu.M

Answer 1

User2019981500 posted

Can you show actual table Design or primarykeys/foriegn keys you are using.

Regards

shabir

Answer 2

User-1716253493 posted

Create Query i.e. Query1

Select risk, Function1 as Function from tb1
union all
Select risk, Function2 as Function from tb1
union all
Select risk, Function3 as Function from tb1
union all
Select risk, Function4 as Function from tb1
union all
Select risk, Function5 as Function from tb1
union all
Select risk, Function6 as Function from tb1
union all
Select risk, Function7 as Function from tb1
union all
Select risk, Function8 as Function from tb1

Then join tbl2 with query1

Answer 3

User2081941926 posted

Thanks for ur reply

how to write join query for 5 tables in Access Data Base

Answer 4

User2081941926 posted

<div>

Answer 5

User2019981500 posted

SELECT U.ID,
       Tbl1.Value1,
       Tbl2.Value2,
       Tbl3.Value3,
       Tbl4.Value4,
       Tbl5.Value3
FROM   (((SELECT ID FROM Tbl1
          UNION
          SELECT ID FROM Tbl2
          UNION
          SELECT ID FROM Tbl3
          UNION         
          SELECT ID FROM Tbl4
          UNION
          SELECT ID FROM Tbl5
          ) AS U
         LEFT JOIN Tbl1 ON U.ID=Tbl1.ID)
        LEFT JOIN Tbl2 ON U.ID=Tbl2.ID)
        LEFT JOIN Tbl3 ON U.ID=Tbl3.ID)
       LEFT JOIN Tbl4 ON U.ID=Tbl4.ID)
       LEFT JOIN Tbl5 ON U.ID=Tbl5.ID;