AnsweredAssumed Answered

JOIN  TWO TABLE (as UNION SELECT)

Question asked by Lub on Jan 21, 2017
Latest reply on Jun 25, 2017 by texas0478

Hi,

I must reply with filemaker a database that is now on Microsoft Access. I would like to join two tables/queries in one report.

I need to have a report in wich I can see both transaction from two tables/queries (in ACCESS SQL this is the statement

 

SELECT tblOrdini.IDordine, tblOrdini.DataOrdine AS Data, qryLibriAsc.Titolo AS Causale, qryDettaglioOrdini.Prezzo AS Importo

FROM qryLibriAsc INNER JOIN (qryDettaglioOrdini INNER JOIN tblOrdini ON qryDettaglioOrdini.OrdineFK = tblOrdini.IDordine) ON qryLibriAsc.IDlibro = qryDettaglioOrdini.LibroFK

UNION ALL SELECT tblOrdini.IDordine, qryPagamenti.DataPagamento AS Data, "Pagamento" AS Causale, qryPagamenti.Importo

FROM qryPagamenti INNER JOIN tblOrdini ON qryPagamenti.OrdineFK = tblOrdini.IDordine

ORDER BY data;

 

IS it possible in FILEMAKER to have this procedure ?

For example:

TBL1: id, date, description, amount

TBL2: id, date, description, amount

 

REPORT:  merge both transaction from two table.

 

 

thanks all

angelo

Outcomes