Query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Query

Author

Topic

vicki
Posting Yak Master

117 Posts

Posted - 2002-03-21 : 15:06:01

Hi,

I want to get all data that I selected from query below and put it into one table but I am not sure how, please help

thanks

1)
SELECT OFC.OCD as OfficeCode,
Domphone.PHNAREA + Domphone.PHNEXCH + Domphone.PHNNUM as BusPhone,
domphone.PHNEXT as BusPhoneExt,
domphone.FAXAREA + domphone.FAXEXCH + domphone.FAXNUM as BusFax,
domphone.FAXEXT as BusFaxExt
FROM OFCNew as OFC LEFT join OFCCNTCTNew as OfficeContact ON OFC.OCD =
OfficeContact.OCD
LEFT join OFCPHNNew as OfficePhone ON OfficeContact.OFC_PHN_UID =
OfficePhone.OFC_PHN_UID
LEFT join DOMPHNNew as DomPhone On OfficePhone.OFC_PHN_UID =
DomPhone.OFC_PHN_UID
WHERE OfficeContact.PHN_USE_TYP='BUS' and OfficePhone.PHN_SUBTYP='D'
2)
SELECT OFC.OCD as OfficeCode,
Domphone.PHNAREA + Domphone.PHNEXCH + Domphone.PHNNUM as EqpPhone,
domphone.PHNEXT as EqpPhoneExt,
domphone.FAXAREA + domphone.FAXEXCH + domphone.FAXNUM as EqpFax,
domphone.FAXEXT as EqpFaxExt,
CNTCT_FNM +''+ CNTCT_MNM +''+ CNTCT_LNM as EqpContact
FROM OFCNew as OFC LEFT join OFCCNTCTNew as OfficeContact ON OFC.OCD =
OfficeContact.OCD
LEFT join OFCPHNNew as OfficePhone ON OfficeContact.OFC_PHN_UID =
OfficePhone.OFC_PHN_UID
LEFT join DOMPHNNew as DomPhone On OfficePhone.OFC_PHN_UID =
DomPhone.OFC_PHN_UID
WHERE OfficeContact.PHN_USE_TYP='EQP' and OfficePhone.PHN_SUBTYP='D'
3)
SELECT OFC.OCD as OfficeCode,
Domphone.PHNAREA + Domphone.PHNEXCH + Domphone.PHNNUM as T16Phones,
domphone.PHNEXT as T16PhoneExt,
domphone.FAXAREA + domphone.FAXEXCH + domphone.FAXNUM as T16Fax,
domphone.FAXEXT as T16FaxExt
FROM OFCNew as OFC LEFT join OFCCNTCTNew as OfficeContact ON OFC.OCD =
OfficeContact.OCD
LEFT join OFCPHNNew as OfficePhone ON OfficeContact.OFC_PHN_UID =
OfficePhone.OFC_PHN_UID
LEFT join DOMPHNNew as DomPhone On OfficePhone.OFC_PHN_UID =
DomPhone.OFC_PHN_UID
WHERE OfficeContact.PHN_USE_TYP='T16' and OfficePhone.PHN_SUBTYP='D'
4)
SELECT OFC.OCD as OfficeCode,
Domphone.PHNAREA + Domphone.PHNEXCH + Domphone.PHNNUM as T2Phones,
domphone.PHNEXT as T2PhoneExt,
domphone.FAXAREA + domphone.FAXEXCH + domphone.FAXNUM as T2Fax,
domphone.FAXEXT as T2FaxExt
FROM OFCNew as OFC LEFT join OFCCNTCTNew as OfficeContact ON OFC.OCD =
OfficeContact.OCD
LEFT join OFCPHNNew as OfficePhone ON OfficeContact.OFC_PHN_UID =
OfficePhone.OFC_PHN_UID
LEFT join DOMPHNNew as DomPhone On OfficePhone.OFC_PHN_UID =
DomPhone.OFC_PHN_UID
WHERE OfficeContact.PHN_USE_TYP='T2' and OfficePhone.PHN_SUBTYP='D'
5)
SELECT OFC.OCD as OfficeCode,
Domphone.PHNAREA + Domphone.PHNEXCH + Domphone.PHNNUM as TTYPhones,
domphone.PHNEXT as TTYPhoneExt,
domphone.FAXAREA + domphone.FAXEXCH + domphone.FAXNUM as TTYFax,
domphone.FAXEXT as TTYFaxExt
FROM OFCNew as OFC LEFT join OFCCNTCTNew as OfficeContact ON OFC.OCD =
OfficeContact.OCD
LEFT join OFCPHNNew as OfficePhone ON OfficeContact.OFC_PHN_UID =
OfficePhone.OFC_PHN_UID
LEFT join DOMPHNNew as DomPhone On OfficePhone.OFC_PHN_UID =
DomPhone.OFC_PHN_UID
WHERE OfficeContact.PHN_USE_TYP='TTY' and OfficePhone.PHN_SUBTYP='D'

Jay99

468 Posts

Posted - 2002-03-21 : 15:58:21


insert into blahblahblah
select
    blahblahblah
union
select
    blahblahblah
union
select
    blahblahblah
union
select
    blahblahblah
union
select
    blahblahblah

Is that what you mean?

Jay
<O>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources