SELECT -- Account_BcustomerTblDao_getBcustomer.sql SURNAME ,NICKNAME ,SURNAMEKANA ,GENDER ,BIRTHDAY ,EMAIL ,EMAIL2 ,PURCHASEFLAG ,SITEFLAG ,POSTCODE ,ADDRESS1 ,ADDRESS2 ,ADDRESS3 ,TEL1 ,TEL2 ,bc.COUNTRYCODE ,COUNTRYDESC1 ,COUNTRYDESC2 ,bc.BCUSTOMERNO ,MAILTYPE ,PAYMENTTYPE ,DELIVERYTYPE ,q.Q1 ,YEAR( BIRTHDAY) AS YBIRTHDAY ,MONTH( BIRTHDAY) AS MBIRTHDAY ,DAY( BIRTHDAY) AS DBIRTHDAY FROM ODRCUS.hmv.vBCUSTOMERTBL as bc (NOLOCK) LEFT JOIN ODRCUS.hmv.COUNTRYTBL as c (NOLOCK) ON bc.COUNTRYCODE = c.COUNTRYCODE LEFT JOIN ODRCUS.hmv.CUSTOMERQUESTTBL as q (NOLOCK) ON bc.BCUSTOMERNO = q.BCUSTOMERNO AND q.QUESTCODE = 2 WHERE bc.BCUSTOMERNO =

CD・DVD・レコード・本・ゲームを売るなら
HMV宅配買取