InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:47:57 GMT20http://www.teradata.com/teradataforum/Topic12474-9-1.aspxThanks Dales, it works.Wed, 13 Aug 2008 06:09:26 GMTIncehttp://www.teradata.com/teradataforum/Topic12474-9-1.aspxSelect * fromVW_Party_Identification where ext_identification_type_cd in (SelectExt_Identification_Type_Cdfrom(select ext_identification_type_cd, rank() over (order by priority asc) rowrank from Priority) subtable1where rowrank=1))How about that?Tue, 12 Aug 2008 15:12:34 GMTDaleshttp://www.teradata.com/teradataforum/Topic12474-9-1.aspxHiI have table A which will be linked to table B containing my pririoty list,Table A is as follows:SELECT party_id ,O_Party_Id ,O_Party_Role_Cd ,Ext_Identification_Num ,Ext_Identification_Type_CdFROM VW_Party_Identification Aand Table BSelect Ext_Identification_Type_Cd ,Priority ,Party_Type_CdFrom Priority B;So how do I join the two queries to make sure that I bring back the highest priority for Party_Id incase party_id has more than one Ext_Identification_Type_Cd.The two tables join on Ext_Identification_Type_Cd.Tue, 12 Aug 2008 05:57:53 GMTIncehttp://www.teradata.com/teradataforum/Topic12474-9-1.aspxIf the table is named LT_IDENTITY, try:select identity_type, identity_type_cd, priority from (select identity_type, identity_type_cd, priority,rank() over (order by priority asc) rowrankfrom LT_IDENTITY) awhere rowrank=1;Mon, 11 Aug 2008 13:22:54 GMTDaleshttp://www.teradata.com/teradataforum/Topic12474-9-1.aspxHiDoes any one knows how to create a query that will pick the highest priority of from the list below,if I have an ID_Number and Passport, the query must pick ID_Number since is the one with the highest priority.Identity Type ID_Type_Cd PriorityID_Number 18 1Passport 15 2Other 0 3Thu, 07 Aug 2008 11:08:38 GMTInce