search for: public_tblartnr

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

2012 Aug 24
1
Regular expressions: stuck again...
...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_ID; Should become: SELECT \&...