I have a problem to create my SQL statement in my report, when I select the tables in the SQL dialog creates the SQL statement including all tables therefore selected and I can see the information correctly, but when I close the dialog and SQL back open, all fields are assigned only to the first table I selecione and loses the other tables. example:
Select articulos.clave, articulos.desc, inventario.existencia, inventario.precio where inventario.clave = articulo.clave
This sentence also use two SQL tables: articulos, inventario but when I open the SQL dialog all fields are referenced to the articulos table
Select articulos.clave, articulos.desc, articulos.existencia, articulos.precio where articulos.clave = articulo.clave
This happens in version 5.6 beta release that day January 10, 2014
Recommended Comments
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now