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.
| Author |
Topic |
|
kidaduo
Starting Member
45 Posts |
 Posted - 2008-03-25 : 11:59:52
|
| Help please!I have two statements getting data from two different tables.1: select dataDate from table1,- gives ‘20080325’2: select count (recordNumber) from table2,-- gives ‘4566’Each table has one row but more than one column. The columns are not the same in each table.Question. I need to combine two statements to give the outcome in one row as '200803254566'. '2008032' from first statement and '54566'from second statement. How do you combine them??Josephine |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-03-25 : 12:01:47
|
SELECT t1.dateDate + t2.ItemsFROM (query1) AS t1CROSS JOIN (query2) AS t2
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
kidaduo
Starting Member
45 Posts |
Posted - 2008-03-25 : 13:05:24
|
Thank u again. Nice job!quote:
Originally posted by Peso
SELECT t1.dateDate + t2.ItemsFROM (query1) AS t1CROSS JOIN (query2) AS t2
E 12°55'05.25"N 56°04'39.16"
Josephine |
|
|
|
|
|
|
Combine two statement