Hi Keith, > select * > from Purchases > left join tblStoreSales > on Purchases.model=tblStoreSales.ISBN > where tblStoreSales.ISBN is null > and Purchases.date<"2008-06-11" > > in Base but not sure how to. Why does it inject all these ` marks? > > All I get is syntax error.
hmm, you should describe in more detail what you're doing ... In general, the ` is the character which the driver reports as so-called "quoting character", to be used for quoting names (table names, column names, ...). Which means the driver should also be able to understand them - and usually it is. So, more details on what you're doing, what versions (MySQL, MySQL driver, OOo) are involved could be helpful. Ciao Frank -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
