I'm trying to create a bit of a complicated query.. it's not finished yet, so if it looks pointless thus far that's why, but right now it complains about an error near "T1".. I thought all returned subtables had to have an alias so.. I've given them all one.. and I can't see what I'm doing wrong here. :/ does anyone see something really blatant? (The column / table names are all correct). For simplicity I reduced it down to this, it still complains...