Re: SQL Subquery and alias for datagrid use




SELECT tbldeal.ID, tblDeal.Seal_Type_ID AS News
FROM tblDeal
WHERE thedate = '7/6/2005' AND Sale_Type_ID < 3

Not sure if I read your post right, is that what you're looking for?

Tom

.