search for: public_tblfich

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

Did you mean: 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_...