Select From Select

[Former Member]

I have a select statement: Select * from A key join B where B.something = something I only want the columns from A to be returned - is this possible without listing all the column names?

[jeff_albion]

I only want the columns from A to be returned - is this possible without listing all the column names?

Yes:

Select A.* from A key join B where B.something = something

[Breck_Carter]

12 seconds! ...you beat me by 12 seconds 🙂

[Former Member]

How simple - thanks very much!!!!

[jeff_albion]

So close! The good news is that it's the same answer - a rarity in SQL re-writes. 🙂

[Breck_Carter]

Select A.* from A key join B where B.something = something