"Simon Longstaff" <[EMAIL PROTECTED]> wrote on
10/28/2005 10:50:24 AM:
> I'm trying to run this :
>
> SELECT DISTINCT A.B_IP FROM w3t_Posts A , w3t_Users B WHERE A.B_PosterID
=
> B.U_Number and B.U_Username = 'user1'
> UNION
> SELECT DISTINCT C.B_IP FROM w3t_Posts C , w3t_Users D WHERE C.B_Pos
I'm trying to run this :
SELECT DISTINCT A.B_IP FROM w3t_Posts A , w3t_Users B WHERE A.B_PosterID =
B.U_Number and B.U_Username = 'user1'
UNION
SELECT DISTINCT C.B_IP FROM w3t_Posts C , w3t_Users D WHERE C.B_PosterID =
D.U_Number and D.U_Username = 'user2'
and it's failing saying
SQL Error:
