hello all,
may i ask is that possible to query from 2 table
first table as the column
and second table as the row

any idea how to do it?

example :
Table 1 :
id name
1 fee
2 wage

Table 2 :
date table1.id Nominal
1 Feb 1 10.000
1 Feb 2 15.000
2 Feb 2 10.000

Result
date fee wage .....
1 Feb 10.000 15000
2 Feb 10000
...