问一个查询的问题

[iceandfire]

现有两张表
A表
user_id
1
2
3
4

B表
user_id lineup timemark
1 1 1149601600000
1 2 1149601500000
2 1 1149601600000
2 2 1149601500000
2 3 1149601300000
3 1 1149601500000

现要找出B表中时间小于等于1149601500000时间值的用户数据，查询结果为

查询结果：
user_id lineup timemark
1 2 1149601500000
2 2 1149601500000
3 1 1149601500000

请问查询语句应该如何写？

[ineedtostudy]

表B给的不清晰

[dennis80]

SELECT user_id,lineup,timemark FROM B WHERE timemark <=1149601500000

[kingofworl]

SELECT * FROM B WHERE timemark <=1149601500000

[hyrongg]

SELECT A.USER_ID,B.LINEUPTIMEMARK FROM A
INNER JOIN B ON A.USER_ID=B.USER_ID AND B.LINEUPTIMEMARK<=149601500000;

[hyrongg]

SELECT A.USER_ID,B.LINEUPTIMEMARK FROM A
INNER JOIN B ON A.USER_ID=B.USER_ID AND B.LINEUPTIMEMARK<=149601500000;

[jiajian008]

SELECT A.USER_ID,B.LINEUPTIMEMARK FROM A
INNER JOIN B ON A.USER_ID=B.USER_ID AND B.LINEUPTIMEMARK<=149601500000;