Problem with the sql statement for making the crystal report

Question

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.mestoTable1.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

Kunal Vaishya · Answer

Hi Explain your relation of database.

Nel · Answer

Hi Kunal Here is the look of the relationships among tables

Nel · Answer

Hi Iftikar I tried this and I got this error Syntax error in JOIN operation.

Iftikar Hussain · Answer

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.mestoTable1.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