[thelist] Really weird ASP problem
mia at miaridge.com
mia at miaridge.com
Fri Jan 25 06:05:00 CST 2002
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)
More information about the thelist
mailing list