This article on Livedocs says you should add the database name in front of tables.http://help.adobe.com/en_US/AIR/1.5/devappsflex/WS5b3ccc516d4fbf351e63e3d118666ade46-7d47. html
My question is, should I do that everywhere where a table name appears or only once?In this query:
select T1.col,T2.col from T1 left join T2 on T1.id=T2.id order by T2.order;
Should I add main.T1 and main.T2 everywhere or just after for, the first time:
select T1.col,T2.col from main.T1 left join main.T2 on T1.id=T2.id order by T2.order;
Retrieving data ...