I have two tables
create table tblchildinfo
(id int, name varchar(50),
pickuppointid int, dropdownpointid int)
and
create table tblpoint(pointid int, PointName varchar(50))
So I have primary table tblpoint and child table as tblchildinfo and i want to write a statement such that i will get child id, child name, pickuppointID, pickuppointName, dropdownpointId & dropdownpoint name
Using SQL Server