|
Hey webmastertalkers,
I have a quite advanced sql statement,
SELECT tPortfolioCategory.tPortfolioCategory_ID, tPortfolioCategory.tPortfolioCategory_Name, tPortfolioCategory.tPortfolioCategory_Active, tPortfolioCategory.tPortfolioCategory_Spacer, tPortfolioCategory.tPortfolioCategory_Order, tPortfolioCategoryLink.tPortfolioCategoryLink_ID, tPortfolioCategoryLink.tPortfolioProject_ID, tPortfolioCategoryLink.tPortfolioCategory_ID AS Expr1, tPortfolioProject.tPortfolioProject_ID AS Expr3, tPortfolioProject.tPortfolioProject_Name, tPortfolioProject.tPortfolioProject_Active
FROM tPortfolioCategory
INNER JOIN tPortfolioCategoryLink ON tPortfolioCategoryLink.tPortfolioCategory_ID = tPortfolioCategory.tPortfolioCategory_ID
INNER JOIN tPortfolioProject ON tPortfolioProject.tPortfolioProject_ID = tPortfolioCategoryLink.tPortfolioProject_ID
WHERE (tPortfolioProject.tPortfolioProject_Active = 1)
The only problem that i have is i need to see if spacer is active in the tPortfolioCategory Table which would make it appear in the record set. the column is tPortfolioCategory_Spacer.
Last edited by beachnerd; 10-12-2006 at 07:50 AM..
|
