简单查询

--单表查询
SELECT T.USER_NAME,T.SEX,T.AGE FROM T_USER T WHERE T.USER_NAME LIKE '%张%'
--多表关联查询
SELECT TU.USER_NAME,TC.COUNTRY_NAEM FROM T_USER TU,T_COUNTRY TC WHERE TU.COUNTRY_CODE = TC.COUNTRY_CODE