Hi - First Post and a question

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

General SQL Server Forums

New to SQL Server Programming

Hi - First Post and a question

Author

Topic

deanfp
Starting Member

26 Posts

Posted - 2011-03-24 : 05:55:15

Hi

I have written a query where SQL is displaying data from two tables but how can we actually join these so we can download to excel?

Thanks!

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-03-24 : 06:08:15

Post the code you used. Also refer this to knwo how to export to excel http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail

deanfp
Starting Member

26 Posts

Posted - 2011-03-24 : 08:27:30

Select
ProdDescription, InternalPrice, TaxCatID, Number01, ShortChar01, ShortChar02, ShortChar03
FROM Part

select *
FROM PartPc
WHERE PcType in ('EAN13','EAN14','EAN15','EAN16')

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-03-24 : 10:04:46

Join the two tables with common column

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources