search for: public_tblfiche

Displaying 1 result from an estimated 1 matches for "public_tblfiche".

2012 Aug 24
1
Regular expressions: stuck again...
...currently reworking a report, originating from a MS Access database, but should be implemented in R. Now I'm facing the task to convert a lot of queries to postgreSQL. What I want to do is make a function which takes the MS Access query as an argument and returns the pgSQL version. So: SELECT [public_tblFiche].[Fichenr], [public_tblArtnr].[Artnr] FROM [public_tblFiche], [public_tblArtnr] WHERE [public_tblFiche].[Artnr_ID] = [public_tblArtnr].[Artnr_ID]; or SELECT public_tblFiche.Fichenr, public_tblArtnr.Artnr FROM public_tblFiche, public_tblArtnr WHERE public_tblFiche.Artnr_ID = public_tblArtnr.Artnr_I...