sql 如何关联ID为string和guid的表

Question

对于表a和表b
select * from a
left join b on a.ID=b.ID
问两个表的id类型不同该如何进行关联

Answer 1

select
CONVERT(uniqueidentifier,'9BEED919-7B6D-42CE-835E-E10CE0D4D10E')as 'String转GUID',
CONVERT(VARCHAR(200),NEWID()) AS 'GUID转String'