Id Name Address 1 SUNIL X 2 Mahesh Y 3 Ajay Z 4 Krunal A
Id Telephone CustId(Foreign Key) 12 393939393 1 13 810241123 1 14 123232332 1 15 1232323 2 16 1232323 2 17 1232323 3
Id Name Address 1 SUNIL X 2 Mahesh Y 3 Ajay Z
SELECT DISTINCT c.id, c.name, c.address FROM customer AS c INNER JOIN addinfo AS a ON a.custid = c.id
select Customer.Name,Customer.Address from Customer inner join AddInfo on Customer.Id=AddInfo.CustId
Select * from Customer where Id In (Select CustID from AddInfo) ------------------------------------------------- --OR ------------------------------------------------- Select distinct CM.* From Addinfo AI Inner Join Customer CM On AI.CustID = CM.Id
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)