Session Error

[DosPrompt]

SelectCommand=" SELECT A.RowID, A.Account AS [Account], A.Relationship AS
[Relationship], B.City AS [City], B.State AS [State], B.Zip AS [Zip],
A.MainPhone AS [MainPhone], A.ProspectStatu s AS [ProspectStatus] FROM
CRM_Accounts AS A INNER JOIN CRM_AddressLook up AS B ON A.AccountID =
B.AccountID WHERE (([Username] = @Username) AND ([Account] LIKE '%' +
@Account + '%') AND ([City] LIKE '%' + @City + '%') AND ([Zip] LIKE '%' +
@Zip + '%') AND ([MainPhone] LIKE '%' + @MainPhone + '%'))"

<SelectParamete rs>
<asp:ControlPar ameter ControlID="strA cct" DefaultValue="% "
Name="Account" PropertyName="T ext"
Type="String" />
<asp:ControlPar ameter ControlID="strC ity" DefaultValue="% "
Name="City" PropertyName="T ext"
Type="String" />
<asp:ControlPar ameter ControlID="strZ ip" DefaultValue="% "
Name="Zip" PropertyName="T ext"
Type="String" />
<asp:ControlPar ameter ControlID="strP hone" DefaultValue="% "
Name="MainPhone " PropertyName="T ext"
Type="String" />
<asp:SessionPar ameter Name="Username" SessionField="s User"
Type="String" />
</SelectParameter s>


I GET THE ERROR
=============== =============== =====
Invalid column name 'A.Username'.

Can someone help me?

- Thanks

[DosPrompt]

Re: Session Error

Never mind!
I got it.

Thanks