jflash
Member
One table "j17_tootetabel":
NAME NR
name1 code1
name2 code2
name3 code3
Second table "j17_kauplused":
NR CODENAME
code1 codename1_1
code1 codename1_2
code3 codename3_1
code3 codename3_2
I have join:
left JOIN j17_kauplused ON j17_tootetabel.NR = j17_kauplused.NR
And join "Display mode": "Each row separately". Am i right, my table needs to view like that if i show only NAME and CODENAME:
NAME CODENAME
name1 codename1_1
name1 codename1_2
name2
name3 codename3_1
name3 codename3_2
When i mark "Display mode": "Merge rows" then my view needs to be:
NAME CODENAME
name1 codename1_1
name2
name3 codename3_1
Or i misunderstood something? If all right, then "Display mode" does not work for me :S
NAME NR
name1 code1
name2 code2
name3 code3
Second table "j17_kauplused":
NR CODENAME
code1 codename1_1
code1 codename1_2
code3 codename3_1
code3 codename3_2
I have join:
left JOIN j17_kauplused ON j17_tootetabel.NR = j17_kauplused.NR
And join "Display mode": "Each row separately". Am i right, my table needs to view like that if i show only NAME and CODENAME:
NAME CODENAME
name1 codename1_1
name1 codename1_2
name2
name3 codename3_1
name3 codename3_2
When i mark "Display mode": "Merge rows" then my view needs to be:
NAME CODENAME
name1 codename1_1
name2
name3 codename3_1
Or i misunderstood something? If all right, then "Display mode" does not work for me :S