mysql 5 vs. mysql 4: str_to_date

The following query runs fine on my test server at home, running MySQL 5.0.15, but on my hosting provider's server, running MySQL 4.0.24, it gets a syntax error. Can anyone help me figure out why? ... insert into product (name, url, cost, purchase_dt) values('Whatchamacallit', 'http://www.whatcha

Re: "left join" record in one joined table and not in another

On 1/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Vincente Aggrippino <[EMAIL PROTECTED]> wrote on 01/11/2006 11:33:38 > PM: > > > I have three tables joined on key fields: delivery is joined with > > invoice_detail on delivery_id and w

"left join" record in one joined table and not in another

I have three tables joined on key fields: delivery is joined with invoice_detail on delivery_id and with location on loc_id. I want to return records of deliveries that have corresponding records in the location table, but have no corresponding records in the invoice table. Here's the query I'm a