Re: From Access2k to mySQL

["Konrad Neitzel" <Konrad.Neitzel_(at)_web.de>]

mysql-de_(at)_lists.4t2.com schrieb am 22.08.00:
> SELECT items.*, quantity.quantitydescshort, vat.vatpercent,
> currency.currencydescshort FROM [currency] JOIN (vat JOIN (quantity JOIN
> items ON quantity.quantityunitid = items.quantityunitid) ON vat.vatid =
> items.vatid) ON currency.currencyid
>  = items.currencyid WHERE items.itemid IN ('2')
Hmm ... just one error i found without searching:
[currency] ???? Just delete the "[]" :)

Just to check this:
mysql> use test
Database changed
mysql> create table test (testid bigint(11) NOT NULL auto_increment, PRIMARY KEY(testid));
Query OK, 0 rows affected (0.97 sec)

mysql> select * from test;
Empty set (0.00 sec)

mysql> select * from [test];
ERROR 1064: You have an error in your SQL syntax near '[test]' at line 1
mysql>

I hope this helps. feel free to mail me any further problems with your SQL Statement.

Greetings,

Konrad Neitzel

PS: Upsa ... englisch geworden ... aber umschreiben tue ich es jetzt nicht...
Sollte auch so jeder verstehen :)

-- 
Konrad Neitzel
Kesselsdorfer Str. 41
01159 Dresden
_______________________________________________________________________
1.000.000 DM gewinnen - kostenlos tippen - http://millionenklick.web.de
IhrName_(at)_web.de, 8MB Speicher, Verschluesselung - http://freemail.web.de

---
*** Abmelden von dieser Mailingliste funktioniert per E-Mail
*** an mysql-de-request_(at)_lists.4t2.com mit Betreff/Subject: unsubscribe