• Registered: 2014-09-06
  • Posts: 805

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

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Get results in one tablegrid from 2 tables ?

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.

Dmitry.
  • Registered: 2014-09-06
  • Posts: 805

Re: Get results in one tablegrid from 2 tables ?

My mistake.
If I use the SQL with the UBION how is the syntax ?

DriveSoft wrote:

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.

4 Reply by kim143 (edited by kim143 2017-05-23 14:47:05)

  • Registered: 2017-04-27
  • Posts: 81

Re: Get results in one tablegrid from 2 tables ?

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)

5 Reply by v_pozidis (edited by v_pozidis 2017-05-24 20:10:23)

  • Registered: 2014-09-06
  • Posts: 805

Re: Get results in one tablegrid from 2 tables ?

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.
                                }

Post's attachments

Attachment icon kati.zip 328.5 kb, 367 downloads since 2017-05-24 

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Get results in one tablegrid from 2 tables ?

v_pozidis
Please provide example of result you need.

Dmitry.