You cannot write entire sql statment in filter string.
syntax for dataTable.Select(string filterexpression)
filterexpression will containt only the part on where clause
It can also containt a sort order as second parameter.
http://msdn.microsoft.com/en-us/library/det4aw50.aspx[
^]
What you are trying can be achieved using LINQ