merging two tables

[arulsettu]

hi

i have two tables accounts and orders with no common field. now how can i create link between these two tables?

[its_anandrjs]

accounts number and account balance are in single table you can use them easily and display its chart where is problem.

[arulsettu]

ya but i am having another table called customer it have country. if i select country have to show account balance.

[arulsettu]

table view

[its_anandrjs]

Try to find out in the database if there is any other table which has a relation ship with this tables then use that table as a link table between the Orders and the Accounts or you can join them also otherwise in the data base create another view that has a relation between the Orders and accounts based on other table and load that view in the qlikview to link the tables.

[arulsettu]

based on table can u give example for join?