Join select statements

[sijugeo]

Hi,

I am using SQL SERVER 2005.
I have two select statements. The code is given below.

-----------1.--------------------------
select d.idx_Delivery, s.idx_Stops,cas e FixedFlag when 1 then Price when 0 then Price*(Percenta ge/100)
else 0 end DeliveryCharge from Tbl_Deliverable s d
inner join Tbl_Stops s on s.idx_Delivery= d.idx_Delivery

-------2-----------------------------------------------

select idx_Stops,sum(t ot) SpecialCharge from(select A.idx_Stops,B.i dx_Specials, case IsFixed when 1 then A.Fee when 0 then A.Fee*(Percenta ge/100)
else 0 end tot from Tbl_SpecialChar ges A
inner join Tbl_Specials B on A.idx_Specials= B.idx_Specials) A group by idx_Stops
------------------------------------------------------------


Now I want to join these two select statements . Please Help

[Shashi Sadasivan]

use the ubion statement

select Query 1
Union all
select query 2

Both queries should return the same number of columns

cheers

[DonlonP]

Simply insert the keyword UNION between the two statements.

[sijugeo]

its not worked.i want results display three columns (after joining the two statements)SpecialCharge,D eliveryCharge,i dx_Stops

[ck9663]

its not worked.i want results display three columns (after joining the two statements)SpecialCharge,D eliveryCharge,i dx_Stops

join using what field as the key?

you could do something like:

select A.keyonA, B.keyonB, A.OtherFields, B.OtherFields from
(select A.keyonA,.... from tableA) A inner/left/right join 
(select B.keyonB.... from tableB)  B on A.KeyonA = B.KeyonB

depending on your requirement, choose whether it's an INNER, RIGHT or LEFT join

[sijugeo]

Thanks a lot. it worked.

:)