Inner Join (id is foreign key)

SELECT *
FROM table1 t1, table2 t2
WHERE t1.id = t2.id


Left Outer Join (id is foreign key)

SELECT *

SELECT table, sum(people)
FROM Tables
GROUP BY table


All aggregate functions (sum, max, min, avg, etc) must include a GROUP BY including all columns up-to the aggregate.

If this is a...

CREATE PROCEDURE CreateWebsiteMember
(
@wbmName varchar(50)
)
AS
INSERT into tblWebsiteMember (Name) VALUES(@wbmName)
SELECT ID as 'Result' FROM tblWebsiteMember where NAME = @wbmName

...

SELECT STATUS.*
FROM STATUS, APPLICATION, GROUPS
WHERE GRP_NAME = 'Group 1' AND GROUPS.GRP_ID = APPLICATION.GRP_ID AND APPLICATION.APP_ID = STATUS.APP_ID