[PHP-DB] DELETE in mysql?

2002-02-01 Thread Adv. Systems Design
sorry if this is painfully obvious but I can't seem to figure it out...It seems to me (unless I am reading it waay wrong) that the mysql DELETE command does NOT allow you to refer to columns from other tables! I have identified certain records to be deleted from 3 tables and created a temp table

[PHP-DB] DELETE in mysql?

2002-02-02 Thread Adv. Systems Design
gt; > -Original Message- > > From: Adv. Systems Design > > [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 01, 2002 2:43 PM > > To: PHP List > > Subject: [PHP-DB] DELETE in mysql? > > > > > > sorry if this is painfully obvious but

RE: [PHP-DB] DELETE in mysql?

2002-02-01 Thread Rick Emery
: Friday, February 01, 2002 2:43 PM To: PHP List Subject: [PHP-DB] DELETE in mysql? sorry if this is painfully obvious but I can't seem to figure it out...It seems to me (unless I am reading it waay wrong) that the mysql DELETE command does NOT allow you to refer to columns from other tables

RE: [PHP-DB] DELETE in mysql?

2002-02-01 Thread Adv. Systems Design
ltiple rows, which > row in temp would MYSQL check against to determine > prod_id? > > > -Original Message- > From: Adv. Systems Design > [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 01, 2002 2:43 PM > To: PHP List > Subject: [PHP-DB] DELETE in mysql?

RE: [PHP-DB] DELETE in mysql?

2002-02-01 Thread Miles Thompson
, which > > row in temp would MYSQL check against to determine > > prod_id? > > > > > > -Original Message- > > From: Adv. Systems Design > > [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 01, 2002 2:43 PM > > To: PHP List > >