Table Aliasname

• kk.86manu

  Ten Centuries

  Points: 1268

  More actions

  December 11, 2012 at 5:05 am

  #393780

  Hello All,

  In the below query, iam giving the alias name for the table1 as 'a' and we already have a table with the same name 'a' in the database.Please let me know whether the condition a.column1 will fetch the records from table1.

  select * from table1 a,table1 b

  where a.column1=b.column1

  Your help will be appreciated.

• nigelrivett

  SSCertifiable

  Points: 5472

  More actions

  December 11, 2012 at 5:16 am

  #1567385

  It will give rows from both aliases (try it and see).

  To just get those from one copy

  select a.* from table1 a,table1 b

  where a.column1=b.column1

  Bit of an odd query though.

  
  Cursors never.
  DTS - only when needed and never to control.