MS SQL: Join query DONT WORK on ASP pages

[afrika]

hello,
am using a join query below to get multiple results from different related tables to form one. e.g

SELECT DISTINCT dbo.e_Wallet.subscriptions, dbo.e_Wallet.username, dbo.e_Wallet.status, dbo.e_Wallet.suspension, dbo.ewalletx_yr_registratn.email, dbo.ewalletx_yr_registratn.Fiscal_Yr, dbo.ewalletx_yr_registratn.end_date, dbo.e_walletpurse.purse
FROM dbo.e_Wallet INNER JOIN dbo.ewalletx_yr_registratn ON dbo.e_Wallet.registrationID = dbo.ewalletx_yr_registratn.registrationID AND dbo.e_Wallet.email = dbo.ewalletx_yr_registratn.email LEFT OUTER JOIN dbo.e_walletpurse ON dbo.e_Wallet.email = dbo.e_walletpurse.email AND dbo.e_Wallet.registrationID = dbo.e_walletpurse.regID
WHERE username = 'variable'


however it dosent seem to work or show any results on my asp page.

What is wrong here ?

thanks

[jimfraser]

Have you tried putting parentheses around the first join operation, eg

SELECT DISTINCT
dbo.e_Wallet.subscriptions,
dbo.e_Wallet.username,
dbo.e_Wallet.status,
dbo.e_Wallet.suspension,
dbo.ewalletx_yr_registratn.email,
dbo.ewalletx_yr_registratn.Fiscal_Yr,
dbo.ewalletx_yr_registratn.end_date,
dbo.e_walletpurse.purse
FROM (dbo.e_Wallet INNER JOIN dbo.ewalletx_yr_registratn
ON dbo.e_Wallet.registrationID = dbo.ewalletx_yr_registratn.registrationID
AND dbo.e_Wallet.email = dbo.ewalletx_yr_registratn.email)
LEFT OUTER JOIN dbo.e_walletpurse
ON dbo.e_Wallet.email = dbo.e_walletpurse.email
AND dbo.e_Wallet.registrationID = dbo.e_walletpurse.regID
WHERE username = 'variable'

[Thing]

however it dosent seem to work or show any results on my asp page.

If your not getting an error message, than your query is fine it just isn't matching any records.

[afrika]

when i run the same query on query analyzer, it gives the desired result.

Well, i would check to see if the problem is with the variable

thanks