Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all
I'm totally new in QV.
I got 2 table. like this
tabel1:
Country , Zone....
AE, 1
AT, 2
AZ, 3
BA, 4
BZ, 5
CZ, 6
table2:
Country, Zone...
AE, 1
AZ, 3
Ba,4
i want to show only existing countries. I dont want to join them. Is there any way to do this.
Well i tried to use where exists function but no luck. Also i tried to search google and qv help but i didnt got any clear answers.
Can someone show me how to do this and describe it liiitle bit?
I know i got some synthetic keys and that's will be my next question ^^
Hi,
use the where exists(table1.country,table2.country)
use alise in table1 Country as Country1
and use in table 2 as where exists(Country1,Country)
it will work. Or post me i will send u a example.
Hi,
use the where exists(table1.country,table2.country)
use alise in table1 Country as Country1
and use in table 2 as where exists(Country1,Country)
it will work. Or post me i will send u a example.
Hi Manesh
Thank you for post. Can u please send me your example.
I think example will be clear to me.
well i solved my problem. The problem was i wrote where exists function wrong that all ^^.
Thank you Manesh