??? --- Michael Kleiser <[EMAIL PROTECTED]> wrote: > select a.*, b.* > from tablea AS a > inner tableb AS b > on a.id=b.aid; > > > CSN schrieb: > > Is it possible to automatically prefix a table > alias > > (or table name or something else even) to each > column > > in a select list? For example: > > > > select a.*, b.* > > from tablea a > > inner tableb b > > on a.id=b.aid; > > > > results: > > > > a_id, a_name, b_id, b_name, b_aid > > > > > > CSN > > > > > > > > > > __________________________________ > > Do you Yahoo!? > > Vote for the stars of Yahoo!'s next ad campaign! > > > http://advision.webevents.yahoo.com/yahoo/votelifeengine/ > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the > unregister command > > (send "unregister YourEmailAddressHere" to > [EMAIL PROTECTED]) > >
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
