Select 2 Table

[#1]

Dear All,

thank for your attention

i have data on mysql, 2 table

1. tbl_personal, key ; id_emp  { id_emp,name}

2. tbl_trans_medical,  { id_emp,date_med,jri,jrj}

3. tbl_bmedical { id_emp, budget_jri, budget_jrj, budget_year}

jri  & jrj : integer

so i want to select 3 tables, but i still confuse if using qlikview

in code mysql : select * from tbl_personal tp, tbl_trans_medical tt, tbl_bMedical tb where tp.id_emp=tt.id_emp and tp.id_emp=tb.id_emp

now i want to load in qlikview  , in order to :

1. want to know sum jri dan jrj ever year group by id_emp

2. chart progress using budget medical

thanks for your help

- Akhrikas Andrias

[geert_gelade]

You can just load the 3 tables in qlikview and the association will be automatically made on fields with the same name.

Script:

tbl_personal:

LOAD id_emp,name

SQL SELECT * FROM tbl_personal

tbl_trans_medical:

LOAD id_emp,date_med,jri,jrj

SQL SELECT * FROM tbl_trans_medical

tbl_bmedical :

LOAD id_emp, budget_jri, budget_jrj, budget_year

SQL SELECT * FROM tbl_bmedical

Once the data is loaded with the script, you can add calculations and charts.

If you upload your data, I can provide you with an example.

[sujeetsingh]

Andrias,

It seems that you have ID_Emp as key for all.

You can use the concept suggested above  and the association will work fine.

You need to do other changes and other key if your requirement uses some other functianality.

[#4]

how to upload my data?

thanks

[geert_gelade]

You can upload files with advanced editor (use button in the right upper corner when you reply).

[#6]

yes, i have id_emp for 3 tables, but primary key just on tbl_personal

- tbl_personal ( table personal employee)

- tbl_trans_medical ( table transaction of medical every month)

- tbl_bmedical ( table budget medical for 1 year

so i want to join that table , inorder to know about sum of jri and jrj every person

[#7]

i still not found that button, , i want to send to your mail, but your mail not appear, thanks

[#8]

thanks before,

1. sheet4-2 : tbl-trans_medical

2. sheet4    : tbl_bmedical

3. sheet4-1 ; tbl_personal

-----------

jri: integer

jrj:integre

tgl_klaim: date

so

1.  I want to know growth every person using jri and jrj on tgl klaim

if i coding in mysql this

-

select year(tgl_klaim) as yearclaim, month(tgl_klaim) as monthclaim, sum(jri), sum(jrj) from tbl_trans_medical tt group by year(tgl_klaim), month(tgl_klaim) order by year(tgl_klaim), month(tgl_klaim)

2. if i select one of person then display budget medical from tbl_bmedical ( brjalan, brinap),

so i must join that tbl_bmedical + tbl_personal+tbl_trans_medical ( like master detail data)

thanks for your attention