Query to list users where firstvisit = lastvisit

UBB.Dev

Hello,

I need a query which will output a list of members that have posted only one message and haven't returned/logged in since then.
Also I would like to see their loginname, email address and the date of their message. Anyone know how to do this ?

Thanks!

Code

<br />SELECT U_LoginName, U_Email, U_LastPostTime<br />FROM w3t_Users<br />WHERE U_LastPostTime = U_Laston<br />AND U_Totalposts = '1'<br />