Phone Brand PhoneID PhoneID PhoneName BrandName
select p.Phone,p.PhoneName,b.Brand,b.BrnadName from Phone p(first Table Name) inner join Brand(Second Table Name) b on p.PhoneID=b.PhoneID
select p.PhoneID ,p.PhoneName ,b.BrandName from Phone p inner join brand b on p.phoneid = b.brandid
insert into brand ( phoneid , brandname) values ( 'phoneid','your brand name')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)