Hi all, i m new to sql... i m facing a problem while executing this query on sql server 2005...

the multipart identifier could not be bound..

SELECT DISTINCT '(' + tblDefProducts.Product_number + ') ' + tblDefProducts.item_name AS Product_number, tblDefProducts.product_id

FROM tblDefProducts

Where 1 = 1

AND tblDefProducts.Gender In (1)

I have a table named tbllineitems having column line_item_id...i want to put a check on it that only the item against selected lineitem should be shown...plzzz help me...thanx in advance..