Re: [ cf-dev ] FW: the equiv in Acess

[Stuart Robinson]

Title: Message

Hi Snake   Is this what you mean?   select r.referer, r.refererID AS RID, (select count(*) from referal_data where refererID = r.refererID) AS Rcount from referers r   OR   select        r.referer,                  r.refererID AS RID,                  count(r_d.refererID) as RCount from          referers r                       left join referal_data r_d                  on r.refererID = r_d.refererID group by     r.referer,                 r.refererID         ----- Original Message ----- From: Snake Hollywood To: [EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 5:35 PM Subject: [ cf-dev ] FW: the equiv in Acess 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