select query in sql server 2008

Question

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

Jimmeh · Accepted Answer · 2009-11-19 10:59:04Z

1

select c.id, c.name, p.name, p.pointid, p2.pointid, p2.name
from tblchildinfo c
join tblpoint p on c.pickuppointid = p.pointid
join tblpoint p2 on c.dropdownpointid = p2.pointid
where <Insert where clause>

should do you.

edited Nov 19, 2009 at 10:59

answered Nov 19, 2009 at 10:38

Jimmeh

2,8721 gold badge22 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

hrishi Over a year ago

I want pickupPointName And PickUpPointId too :)

Jimmeh Over a year ago

I've added that in. You just add a selector for each of the fields you want. The join ensures that fields from both tables are available.

hrishi Over a year ago

I appreciate ur help buddy...but i want dropdownpoint name too... ie out put with two different name and two diffrent Ids tnx

Jimmeh Over a year ago

I've editted it for you. It works, but i'm not sure it's good practice to use joins like that :)

HLGEM Over a year ago

You might need left joins on both of those if you can't guarantee that the parent record will have both

Ben · Accepted Answer · 2009-11-19 10:38:30Z

0

Use a conditional query over two tables or use a LEFT JOIN on tblpoint. Btw, for readability i sugguest using unserscores for 'multi-word-name' tables, such as tbl_child_info and tbl_point.

answered Nov 19, 2009 at 10:38

Ben

11.3k19 gold badges80 silver badges140 bronze badges

2 Comments

hrishi Over a year ago

I appreciate ur help buddy...but i want dropdownpoint name too... ie out put with two different name and two diffrent Ids tnx

Aaron Bertrand Over a year ago

While the tbl prefix is useless, the use of under_scores vs. CamelCase for readability is totally subjective. I prefer CamelCase in table names, but that is because I find them easier to read and type than underscores. YMMV.

Collectives™ on Stack Overflow

select query in sql server 2008

2 Answers 2

5 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related