CREATE TABLE MEMBER (
 USERID VARCHAR(10)
 , NAME VARCHAR(10)
 , TYPE VARCHAR(10)
)
GO

CREATE TABLE INFOR (
 USERID VARCHAR(10)
 , NAME VARCHAR(20)
 , POINT INT
)
GO

INSERT INTO MEMBER
 SELECT 'AAA', '길동이', '똥차' UNION ALL
 SELECT 'BBB', '희동이', '세단'
GO
INSERT INTO INFOR
 SELECT 'AAA', '길동이 카드', 100 UNION ALL
 SELECT 'BBB', '희동이 카드', 200 UNION ALL
 SELECT 'AAA', '길동이 카드 두번째', 300
GO
SELECT * FROM MEMBER
SELECT * FROM INFOR

--RESULT
--USERID     NAME       TYPE
------------ ---------- ----------
--AAA        길동이        똥차
--BBB        희동이        세단
--
--(2 row(s) affected)
--
--USERID     NAME                 POINT
------------ -------------------- -----------
--AAA        길동이 카드               100
--BBB        희동이 카드               200
--AAA        길동이 카드 두번째           300
--
--(3 row(s) affected)

SELECT
 A.USERID
 , A.NAME
 , B.*
FROM
 MEMBER A
INNER JOIN
 (SELECT
  USERID
  , NAME1 = MAX(CASE WHEN RK = 1 THEN NAME END)
  , POINT1 = MAX(CASE WHEN RK = 1 THEN POINT END)
  , NAME2 = MAX(CASE WHEN RK = 2 THEN NAME END)
  , POINT2 = MAX(CASE WHEN RK = 2 THEN POINT END)
 FROM (
  SELECT
   *
   , RK = (SELECT COUNT(*) FROM INFOR Y WHERE X.USERID = Y.USERID AND X.NAME >= Y.NAME)
  FROM INFOR X
  ) Z
 GROUP BY USERID
 ) B
ON A.USERID = B.USERID

--RESULT
--USERID     NAME       USERID     NAME1                POINT1      NAME2                POINT2
------------ ---------- ---------- -------------------- ----------- -------------------- -----------
--AAA        길동이        AAA        길동이 카드               100         길동이 카드 두번째           300
--BBB        희동이        BBB        희동이 카드               200         NULL                 NULL
--Warning: Null value is eliminated by an aggregate or other SET operation.
--
--(2 row(s) affected)