Database

insert table3(email)
select distinct email from table1
union
select distinct email from table2

CalendarSpan
============
CalendarSpanId    INTEGER     --AutoNumber(Identity) primary Key
TimeOrder         INTEGER     --The order of when this Era/Age occurs (0=Earliest)
Era               TEXT(30)    --The Era 
Age               TEXT(30)    --The Age within the Era

GROUPS
|----CATEGORIES
     |----SKILLS
          |----SUBSKILLS  

SKILLSINAGES
=================
SkillInAgesId - Primary Key
AgeCode
SubSkillCode

SELECT
		...
FROM
		(
			(
				(
					CATEGORYGROUPS AS cg
					LEFT JOIN CATEGORY AS c
						ON cg.GroupCode = c.GroupCode
				)
				LEFT JOIN SKILLS AS s
					ON (c.CategoryCode = s.CategoryCode)
					AND (c.GroupCode = s.GroupCode)
			)
			LEFT JOIN SUBSKILLS AS ss
				ON (s.GroupCode = ss.GroupCode)
				AND (s.CategoryCode = ss.CategoryCode)
				AND (s.SkillCode = ss.SkillCode)
		)
		LEFT JOIN SKILLSINAGES sia
			ON (cg.GroupCode = sia.GroupCode)
			AND (c.CategoryCode = sia.CategoryCode)
			AND (s.SkillCode = sia.SkillCode)
			AND (ss.SubSkillCode = sia.SubSkillCode)
WHERE
		...

SELECT
		...
FROM
		CATEGORYGROUPS AS cg
		LEFT JOIN CATEGORY AS c
			ON cg.GroupCode = c.GroupCode
		LEFT JOIN SKILLS AS s
			ON (c.CategoryCode = s.CategoryCode)
			AND (c.GroupCode = s.GroupCode)
		LEFT JOIN SUBSKILLS AS ss
			ON (s.GroupCode = ss.GroupCode)
			AND (s.CategoryCode = ss.CategoryCode)
			AND (s.SkillCode = ss.SkillCode)
		LEFT JOIN SKILLSINAGES sia
			ON (cg.GroupCode = sia.GroupCode)
			AND (c.CategoryCode = sia.CategoryCode)
			AND (s.SkillCode = sia.SkillCode)
			AND (ss.SubSkillCode = sia.SubSkillCode)
WHERE
		...

SELECT TableA.ID as AID, TableB.ID as BID, TableC.ID as CID
FROM TableA
INNER JOIN TableB ON TableA.ID = TableB.AID
INNER JOIN TableC ON TableB.ID = TableC.BID

"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar

The Second EuroCPian Event will be in Brussels on the 4th of September

Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!

My Blog

CREATE FUNCTION DateOnly
(
     @Test_DT DATETIME
)
RETURNS DATETIME
AS
BEGIN
     DECLARE @tmp DATETIME
     SET @tmp = CAST(CONVERT(VARCHAR(20),@Test_DT,101) AS DATETIME)
     RETURN @tmp
END

DECLARE @Yesterday DATETIME
SET @Yesterday = DATEADD(d,-1,dbo.DateOnly(GETDATE()))
SELECT * FROM Document WHERE ProcessDate = @Yeseterday