[ cf-dev ] FW: the equiv in Acess

[Snake Hollywood]

Title: Message

did everyone just get this when I sent to the database list?   -----Original Message----- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 01 June 2004 14:59 To: 'Snake Hollywood' Subject: the equiv in Acess I need to do this query in Access, but Access doesn't support referencing outer aliases   select referer, refererID AS RID, (select count(*) from referal_data where refererID = RID) AS Rcount from referers   what the appropriate syntax anyone?   Russ