SQL query problem

[Floodster]

Hi,
I have an SQL query which works no problem on my LOCALHOST, the problem occurs when I try running it on my live server. The error I get it;

Error

SQL-query :  

SELECT tbl_DATASET_LIBRARY.LIBHEADERID, tbl_DATASETS_HEADER.txtHeader
FROM tbl_DATASETS
INNER JOIN (

tbl_DATASETS_HEADER
INNER JOIN tbl_DATASET_LIBRARY ON tbl_DATASETS_HEADER.txtHeader_id = tbl_DATASET_LIBRARY.LIBHEADERID
) ON tbl_DATASETS.ID = tbl_DATASET_LIBRARY.LIBDATASETSID
GROUP BY tbl_DATASET_LIBRARY.LIBHEADERID, tbl_DATASETS_HEADER.txtHeader, tbl_DATASETS.txtmost_requested
HAVING (
(
(
tbl_DATASETS.txtmost_requested
) = "Y"
)
)
ORDER BY tbl_DATASET_LIBRARY.LIBHEADERID
LIMIT 0 , 30 

MySQL said: 


Unknown column 'tbl_DATASETS.txtmost_requested' in 'having clause'

Can anybody see a problem with this??
I have checked to make sure both tables have the same properties etc.
Thanks.

 

[Floodster]

I found the problem, I was not selecting the column txtmost_requested in my query.

Sorry!!!!