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 |
|
Techsavy
Starting Member
4 Posts |
 Posted - 2008-05-14 : 00:36:57
|
| Hi,I have a 3 tables with two columns in each table Table 1 -Date Flow1Table 2 -Date Flow2Table 3 -Date Flow3Date is the primary key and I would Like to have one table with Date ,flow1, flow2, flow3.How do I do an inner join at once to get this table.Thanks, |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-05-14 : 01:52:47
|
| Create this as a CrossTab query, then make a table from the results. |
 |
|
|
|
|
|
Inner join with multiple tables-urgent