Displaying 1 result from an estimated 1 matches for "tblartnr".
2012 Aug 24
1
Regular expressions: stuck again...
...ating 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 \&...