Demand Table Id Varient Country 1 v1 India 2 v2 NULL 3 v3 Nepal 4 v4 Japan VarientCountry Table Id Varient Country 1 v1 India 2 v1 Uk 3 v2 China 4 v1 Indonisia 5 v3 Nepal 6 v4 Egland 7 v4 Null I want Excepted Result like as Id Varient Country 1 v1 UK 3 v2 China 6 v4 England
I want Excepted Result like as Id Varient Country 1 v1 UK 3 v2 China 6 v4 England
SELECT vc.* FROM VarientCountry vc LEFT JOIN Demand d ON d.Country = vc.Country WHERE d.Country IS NULL
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)