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 |
|
andrewcw
Posting Yak Master
133 Posts |
 Posted - 2009-03-13 : 14:16:02
|
| If I have a select that reurns a table with 2 columns col1, Col2 what is that tables's name to make a join with a real table's column ? Is this possible? { actual table query is more complex, but I get the same error as this sample - Syntax error in From clauseSelect TableA.colA, memTable.Col1 from TableATableA JOIN memTable on TableA.colA = memTable.Col1Select TableB.Co1, TableB.Col2 from TableB as memTable where TableB.z= 'fun'TABLEA ColA ColB0 foo1 fredTABLEBCol1 Col2 z1 some fun0andrewcw |
|
|
|
|
|
Can this be done ? join to select output