SELECT u.UserId, u.UserName, u.Location, o.OrderNo From UserInfromation u INNER JOIN OrderInformation o ON u.UserId = o.UserId;
select UserId, UserName, Location, OrderNo from UserInfromation,OrderInfromation where UserInfromation.UserId= OrderInfromation.Userid
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)