Join Condition

[NavinReddy]

Hi All,

im get confused help some one

Dimention     Transparent

product          county     

A                   BNG

B                   DL

C                   MB

D                   KL

Dimention to transparent or transparent to dimension

which is the better Display option by using join condition       

Thanks & Regards

Niranjan

[sujeetsingh]

Niranjan i am not able to get it .

What you are joining?

[NavinReddy]

Hi Sardar,

Those are Two tables  Dimention,Transparent

While joining these two tables which is better way to join

leftjoin or rightjoin (and why )

could you plz explain

Thanks & Regards

Niranjan

[er_mohit]

I think

if you have 1000 records in dimenson and less records in transparent then most probably do left if vice versa then right

if you want to keep records oon the basis of dimension tab and doesnt wnt to join

then use left keep

or vice versa then right keep

hope it helps

[sujeetsingh]

Niranjan first of all you have a common key for joining in both table .

You can use joins based on what you want and density of your data in both table.

You can try concatenate too.

So first get all stuffs of requirement to be implemented.

[narender123]

Hi,

take the master table 1st and then left join 2nd table with 1st.

Or you make the outer join by taking one similar column in both table and other columns which are same in both table,rename them. and for this you dont need to write left or right join between these tables.

Thanks

Narender

[Joaquin_Lazaro]

HI niranjan123

This document contains an example of all the possible joins with QV.

Please, review the document and then use the best join to get the result that you need on every qvw.