With TableA ([key],col)
AS
(SELECT 1,'1308064*8' UNION ALL
 SELECT 2, '1522323*11'
),
 TableB ([key],col)
AS
(SELECT 1,'Some Stuff' UNION ALL
 SELECT 2, 'Other Stuff'
 )
 Select A.col ,*
 from tableA A
left join tableB B
on a.[key] = b.[key]