Last post May 13, 2013 11:54 PM by oned_gk
May 13, 2013 09:49 PM|jesusw00t|LINK
Im doing a website using VS2010 and using a SQLDataSource that connects to an access 2000 file with three tables. Post,Friends and Members and am trying to use this query inside the "define custom statement or stored procedures" SELECT box
SELECT (Members.First_Name + " " + Members.Last_Name)AS Member,
WHERE My_E_Mail = ? and Friend_E_Mail <> ?
WHERE Friend_E_Mail = ?and My_E_Mail <> ?)) AS E_Mail_Name,
(Members.First_Name) AS Name
PS the "?" are query string parameters that im passing in the asp.net code i know that works fine.
MY QUESTION IS : i keep getting this error "Operation Not Allowed in Sub Query" is their a work around query i can use without using Another table?
May 13, 2013 11:54 PM|oned_gk|LINK
Create a query, then select * from query1 where ...