https://netsuiteprofessionals.com logo
j

jen

04/27/2022, 7:18 PM
Anyone know why I can’t do a
WHERE user = <number>
in a
SELECT * FROM loginaudit
?
t

tdietrich

04/27/2022, 7:54 PM
That is odd, and I'm seeing that, too. What you can do - and I have no idea why this works - is something like this...
Copy code
SELECT TOP 10
	LoginAudit.*
FROM
	LoginAudit
	INNER JOIN Employee ON
		( Employee.ID = LoginAudit.User )
WHERE
	Employee.ID = <number>
j

jen

04/27/2022, 9:41 PM
gak
I’ll just get my desired user’s email addresses first and filter on that instead