Hello! I start programming on vb.net and I have encountered a problem.
I realize a program in which I simulate three operations that generate income for me.
In the same database, I generated 3 tables (
tabla1, tabla2, tabla3) and all 3 have the same columns:
SERIE , OPERACION Y MONTO.
SERIES as idKey, Surgery It is a fixed datum that is different for each operation: OP1, OP2 and OP3 and the Amount What's one? decimal (10.2). Everyone has the same configuration
Now my question is, after trying the program and adding data. I expected that during the consultation in SQL (at the moment, I use the Visual Studio query generator), I run a sort of table with 3 columns with all the values and at the end the sum of the amounts.
But instead, he throws me 9 columns, the 3 of each table.
and I do not know how to search this question directly on Google.
I hope you can help me, sorry if it's something simple, come learn! Thank you