[thelist] Really weird ASP problem

[mia at miaridge.com]

On Thu, 24 Jan 2002, Jason Lustig wrote:

> SELECT name, update, boardpic FROM chapter WHERE id=99999
>
> ... it will work... the SQL code that I want it to work with just doesn't
> work. Is there a reserved word that Access uses in that code that I'm
> missing?

If the above works where your original query "SELECT b.name, b.email,
bp.bpname FROM board b, board_position bp WHERE b.position=bp.id and
b.chapter='99999'" doesn't, could it be that Access doesn't support
aliasing?  (i.e. board b, board_position bp)

Does something like "SELECT b.name, b.email, bp.bpname FROM board AS b,
board_position AS bp WHERE b.position=bp.id and b.chapter='99999'" or a
fully spelt-out version work?

Fully written out, I guess it would be "SELECT board.name, board.email,
board_position.bpname FROM board, board_position WHERE board.position =
board_position.id and board.chapter='99999'".

cheers, Mia
(I know nothing about Access so I could be well wrong)