Select SponsorID, CompanyName, Headline, Categories From Sponsors Where SponsorStatus = 'Active' Order by Categories,CompanyName Delete From SponsorsTempCategories Insert Into SponsorsTempCategories (SponsorID, CompanyName, Headline, Category) Values ('#getActiveSponsorRecords.SponsorID#','#Trim(getActiveSponsorRecords.CompanyName)#','#Trim(getActiveSponsorRecords.Headline)#','') Insert Into SponsorsTempCategories (SponsorID, CompanyName, Headline, Category) Values ('#getActiveSponsorRecords.SponsorID#','#Trim(getActiveSponsorRecords.CompanyName)#','#Trim(getActiveSponsorRecords.Headline)#','#Trim(CategoryName)#') Select SponsorID, CompanyName, Headline, Category From SponsorsTempCategories Group by Category, CompanyName, Headline, SponsorID Order by Category, CompanyName, Headline MomTalk.com - Advertising Sponsors - Women's magazine about children, family, health, home deco, fashion, careers, & marriage issues.