RE: updating table 1 where table 2 condition? & join

ope this helps Quentin -Original Message- From: Richard Creech - DreamRiver.com [mailto:[EMAIL PROTECTED]] Sent: Friday, 9 March 2001 2:45 p.m. To: [EMAIL PROTECTED] Subject: updating table 1 where table 2 condition? & join Hello All, Two items: 1. UPDATING TABLE 1 WHERE TABLE 2

updating table 1 where table 2 condition? & join

Hello All, Two items: 1. UPDATING TABLE 1 WHERE TABLE 2 CONDITION Is it still true I cannot update table 1 on a table 2 field condition? example: UPDATE member SET member.acluser='6' where payment.memberexpires < '2001-03-09' ... big sigh ... 2. JOIN SYNTAX I need help with a specific join sy