quote:

---

Originally posted by ivra

Hi,

I always get this error message when I run my script.


SELECT Count(UserInfo.user_id) AS CountOfuser_id, UserInfo.country
FROM UserInfo LEFT JOIN (ListingInfo INNER JOIN
CheckoutInfo ON ListingInfo.item_id =
CheckoutInfo.item_id) on UserInfo.user_id = ListingInfo.seller_id
Left JOIN ListingDisputeInfo
ON ListingInfo.item_id = ListingDisputeInfo.item_id
GROUP BY UserInfo.country
HAVING (((Count(UserInfo.user_id)) In (SELECT User_ID FROM
month(auct_end_date)=10)) AND ((UserInfo.country)='UK')
AND Payment_mthd_lookup.payment_mthd_desc='PayPal'
AND ((Count(ListingDisputeInfo.item_id))>1))

Error Message:

Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'ON'.
Msg 102, Level 15, State 1, Line 8
Incorrect syntax near 'Count'.
Msg 102, Level 15, State 1, Line 9
Incorrect syntax near '='.

Can someone let me know what's wrong with the script. thanks

---

SELECT		Count(UserInfo.user_id) AS CountOfuser_id, 
		UserInfo.country
FROM		UserInfo 
LEFT JOIN	(
			SELECT		ListingInfo.seller_id
			FROM		ListingInfo
			INNER JOIN	CheckoutInfo ON ListingInfo.item_id = CheckoutInfo.item_id
		) AS x ON x.seller_id = UserInfo.user_id
GROUP BY	UserInfo.country

DECLARE	@t1 TABLE
	(i inT)

insert @t1 select 1 union all select 2

DECLARE	@t2 TABLE
	(j inT)

insert @t2 select 1

DECLARE	@t3 TABLE
	(k inT)

insert @t3 select 1 union all select 2 union all select 3

-- bklr
SELECT		*
FROM		@t1 as t1
LEFT JOIN	@t2 AS t2 ON t2.j = t1.i
INNER JOIN	@t3 AS t3 ON t3.k = t2.j

-- Peso
SELECT		*
FROM		@t1 as t1
LEFT JOIN	(
			SELECT		*
			FROM		@t2 AS t2
			INNER JOIN	@t3 AS t3 ON t3.k = t2.j
		) AS x ON x.j = t1.i