Joins

FROM <TABLE A>
	[TYPE] JOIN <Table B>
		ON <A Field> = <B Field>

Cross Join	Inner Join	Left Join
Full Outer Join	Right Join	Left Join Where Null

---

Children

1. Cross Join
2. Full Outer Join
3. Inner Join
4. Left Join
5. Left Join Where Null
6. Right Join