Thanks for tip, I`ve been doing a bit of reading up and have solved the problem.
Your advice will be stored for future reference, thanks. On Wed, 2003-04-02 at 21:31, Michael Shulman wrote: > You can't use a JOIN on an insert, only on a SELECT. > > The (simplest) syntax for INSERT is > > INSERT INTO <tablename> (col1, col2, col3) VALUES (val1, val2, val3) > > You can also INSERT as a result of a SELECT, but that's not what you want. > > Unfortunately, you will need to create multiple INSERT statements to keep > the referential integrity solid. > > If you use InnoDB, you can wrap your INSERT statements into a transaction so > that they all are committed as a group. That way, you won't be left with > dangling inserts without corresponding values in other tables if your insert > fails. > > -ms > > > -----Original Message----- > From: Chris Blake [mailto:[EMAIL PROTECTED] > Sent: Friday, March 28, 2003 1:37 AM > To: [EMAIL PROTECTED] > Subject: Join Statement > > Greetings MySQL folk, > > New to MySQL.....here goes. > > Have db with following tables : > > Client : > ClientID | ClientName | Address | Distance | ContactName | ContactNo > > Jobs : > JobID | ClientID | JobDate | JobDistance | JobWorkDone | JobTimeTaken | > JobTypeID > > JobTypes : > JobTypeID | JobDesc > > I need to create a JOIN statement in MySQL that will update the db but I > can`t get it right : > > Heres the (partial) code, it`s been through so many amendments I`ve > actually got myself in a knot here. > > //Create SQL to Update Job Info-------------------- > $sqlSaveJob = "INSERT INTO Jobs INNER JOIN ON JobTypes" . > $sqlSaveJob = "SET ClientID = '$ClientID',". > $sqlSaveJob = " JobDate = $JobDate1,". > $sqlSaveJob = " JobTypesID = $JobTypesID,". > $sqlSaveJob = " Distance = $Distance,". > $sqlSaveJob = "WHERE ClientID = '$ClientID'" ; > > Any pointers.....this is rather confusing. I may be a dufus cus I read > the MySQL docs but it don`t make any sense. > > -- > Chris Blake > Office : (011) 782-0840 > Cell : 083 985 0379 > A chicken is the eggs way of producing more eggs. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- Chris Blake Office : (011) 782-0840 Cell : 083 985 0379 Linux vs. Windows is a no-WIN situation. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
