Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets   Hide Images
Bewarse Talk Discussion Board * Archives - 2015 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through January 01, 2015 * SQL Help < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Superman
Kurra Bewarse
Username: Superman

Post Number: 1190
Registered: 10-2005
Posted From: 71.63.229.222
Posted on Friday, December 19, 2014 - 6:17 pm:    Edit Post Delete Post Print Post

how abt this..


get distinct column names from two tables in teradata
Top of pagePrevious messageNext messageBottom of page Link to this message

Mrbezawada
Pilla Bewarse
Username: Mrbezawada

Post Number: 36
Registered: 10-2011
Posted From: 205.172.134.23
Posted on Friday, December 19, 2014 - 4:46 pm:    Edit Post Delete Post Print Post

Question clear ga ledu uncle

SELECT DISTINCT COL1, COL2
FROM TABLENAME1 a
INNER JOIN TABLENAME2 b
ON a.COL = b.COL
Bezawada Bewarse Batchey
Top of pagePrevious messageNext messageBottom of page Link to this message

Superman
Kurra Bewarse
Username: Superman

Post Number: 1187
Registered: 10-2005
Posted From: 71.63.229.222
Posted on Friday, December 19, 2014 - 4:18 pm:    Edit Post Delete Post Print Post

column names
Top of pagePrevious messageNext messageBottom of page Link to this message

Kittigadu
Kurra Bewarse
Username: Kittigadu

Post Number: 1803
Registered: 12-2011
Posted From: 170.88.180.1
Posted on Friday, December 19, 2014 - 4:12 pm:    Edit Post Delete Post Print Post

columns names or data in columns?!
Inka Decide cheyyaleee
Top of pagePrevious messageNext messageBottom of page Link to this message

Superman
Kurra Bewarse
Username: Superman

Post Number: 1185
Registered: 10-2005
Posted From: 71.63.229.222
Posted on Friday, December 19, 2014 - 4:04 pm:    Edit Post Delete Post Print Post

need help


SQL to get distinct column names from two tables

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration