问mysql嵌套select输出值为N/A？

提问于 2021-12-14 12:13:50

回答 1关注 0查看 377

SELECT
	mobile 
FROM
	travel_record 
WHERE
	basestation_id = 8 IN (
	SELECT
		mobile 
	FROM
		travel_record 
	WHERE
		( in_time BETWEEN ADDDATE( '2021-10-09', INTERVAL - 48 HOUR ) AND '2021-10-09' ) 
		OR ( out_time BETWEEN ADDDATE( '2021-10-09', INTERVAL - 48 HOUR ) AND '2021-10-09' ) 
		OR (
		UNIX_TIMESTAMP( out_time ) > UNIX_TIMESTAMP( '2021-10-09' ) 
	AND UNIX_TIMESTAMP( in_time ) <= UNIX_TIMESTAMP( '2021-10-09' )))

两个select分开写都能正常输出值，但是嵌套后的代码输出的值是N/A，应该怎么改？