JOIN-VarBinary

• pzmrcd

  Default port

  Points: 1419

  More actions

  October 17, 2008 at 11:17 am

  #192339

  Hi

  If I have 2 tables tbl1,id(varbinary(18)AS PK) and tbl1, having id(varbinary(18)AS PK) can I join the 2 tables on ID.

  Thanks

• noeld

  SSC Guru

  Points: 96590

  More actions

  October 17, 2008 at 12:06 pm

  #886559

  pzmrcd (10/17/2008)

  ---

  Hi

  If I have 2 tables tbl1,id(varbinary(18)AS PK) and tbl1, having id(varbinary(18)AS PK) can I join the 2 tables on ID.

  Thanks

  sure you can.

  
  * Noel

• zaheer.timol

  SSC Enthusiast

  Points: 155

  More actions

  June 19, 2018 at 6:22 am

  #1994430

  hi,
      I am having the same problem .
  my join is not working properly . Can some guru please help
  Thank you
  Zee
  

  SELECT *

    FROM [X].[dbo].[DomainCmsTde] dc

  full join   master.sys.certificates c on dc.thumbprint1 = CONVERT(varchar(max), c.thumbprint, 0)