Problem with the sql statement for making the crystal report

Nel

Hello,
I have to take several fields from several tables and write the commandtext to make my CrystalReport, but I have problem with connecting the tables. The database I use is Ms Access.
Here is the commandtext I wrote:
string comstring1 = "Select Table1.Rbr, Table1.mbr, MATDAT.PRIME, SIFRAB.IMEZAN, ORGDAT6.IOE, Table1.sifra, Table1.nazivnatema, Table1.propisi, Table1.datumod, Table1.datumdo, Table1.mesto,Table1.izveduvacnaobuka from MATDAT inner join Table1 on MATDAT.MBR=Table1.mbr join ORGDAT6 on MATDAT.PE=ORGDAT6.PE join SIFRAB on SIFRAB.RABMES=MARDAT.RABMES order by Table1.Rbr asc";

but when I run the windows forms application I get an error:
Syntax error (missing operator) in query expression 'MATDAT.MBR=Table1.mbr join ORGDAT6 on MATDAT.PE=ORGDAT6.PE join SIFRAB on SIFRAB.RABMES=MARDAT.RABMES'.

Can anybody help me how to write the commandtext of the command correctly please?

Thank you in advance

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kunal Vaishya13y ago
Accepted answer
Hi,

Explain your relation of database.
Nel13y ago
Hi Kunal,
Here is the look of the relationships among tables
Nel13y ago
Hi Iftikar,

I tried this and I got this error
"Syntax error in JOIN operation."
Iftikar Hussain13y ago
Hi,
Try like this

Select Table1.Rbr, Table1.mbr, MATDAT.PRIME, SIFRAB.IMEZAN, ORGDAT6.IOE, Table1.sifra,
Table1.nazivnatema, Table1.propisi, Table1.datumod, Table1.datumdo, Table1.mesto,Table1.izveduvacnaobuka
from
(((MATDAT inner join Table1 on MATDAT.MBR=Table1.mbr) join ORGDAT6 on MATDAT.PE=ORGDAT6.PE)
join SIFRAB on SIFRAB.RABMES=MARDAT.RABMES) order by Table1.Rbr asc

Regards,
Iftikar