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 |
|
OldMySQLUser
Constraint Violating Yak Guru
301 Posts |
 Posted - 2008-02-01 : 04:51:50
|
| I wish to SELECT all the fields from a 52-field table, but use a JOIN later in the query using one of the fields (Payment_Method) for that JOIN. So I will have:t2.description AS Payment_Method,as part of the SELECT portion of the query. How can I reference the Payment_Method field without causing ambiguity with the SELECT *? I don't want to have to list every other field manually. Is there a way to do this please?I have to keep the field name Payment_Method as a PHP script will be using it. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-01 : 08:16:33
|
| Sorry your requirement is not clear. WHich table are you taking JOIN with? Can you explain with some sample data? |
 |
|
|
|
|
|
Field referencing question