Topic: Get results in one tablegrid from 2 tables ?
Is there a way to get results pressing one button to have from two tables results in one tablegrid ?
If yes youd you send an example ?
Thank you in advance
My Visual Database → General → Get results in one tablegrid from 2 tables ?
Is there a way to get results pressing one button to have from two tables results in one tablegrid ?
If yes youd you send an example ?
Thank you in advance
Yes, if tables have relationship. Also you can use SQL query and keyword UNION to get results from two tables without relationship.
Please provide a concrete case.
My mistake.
If I use the SQL with the UBION how is the syntax ?
Yes, if tables have relationship. Also you can use SQL query and keyword UNION to get results from two tables without relationship.
Please provide a concrete case.
union example
SELECT textr FROM tabone
UNION
SELECT textl FROM tabtwo;
using relationship and inner join
SELECT
tabone.textr,
tabtwo.textl
FROM
tabtwo
INNER JOIN tabone ON (tabtwo.id_tabone = tabone.id)
Is it possible to fix it using my attached software, so I could understand it .
{
In my sample I like to get datas from two tables in one tablegrid sorted by the date and the Lastname should be in the same column
You send me that this is possible with the union command. I do not know how to do it so I
need your help.
}
v_pozidis
Please provide example of result you need.
My Visual Database → General → Get results in one tablegrid from 2 tables ?
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi