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? |
Yes: Select A.* from A key join B where B.something = something Replies hidden
How simple - thanks very much!!!!
(23 May '13, 17:00)
AustinDrum
2
So close! The good news is that it's the same answer - a rarity in SQL re-writes. :)
(23 May '13, 17:04)
Jeff Albion
Comment Text Removed
|
Select A.* from A key join B where B.something = something |