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
frank.schoenheit@... -
- Sun Microsystems
http://www.sun.com/staroffice -
- OpenOffice.org Base
http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail:
users-unsubscribe@...
For additional commands, e-mail:
users-help@...
