Help Guys! SQL problem (Access)

[jocno1212]

Guys patulong naman, may dalawang table kasi ako, ang objective ko kasi e mapagsama sa iisang query yung lahat ng collection within the day galing sa dalawang tables ko,

example

Table1
ClientID........BillAmt.....DateRec
1..................50...........01/01/2016
2..................100.........01/01/2016
3..................150.........01/02/2016
4..................200.........01/03/2016
5..................250.........01/04/2016

Table2
ClientID........InstallationFee.....DatePaid
6..................1,000..................01/01/2016

Gusto ko sana maging ganito output ng QUERY ko

Query1
ClientID........BillAmt........InstallationFee....DateRec..................DatePaid
1..................50..............0........................01/01/2016............-
2..................100............0........................01/01/2016............-
6..................0................1,000................................................01/01/2016

Paano ba yung tamang SQL code nito,

Ano po ba mali dito?

SELECT
Table1.ClientID,
Table1.BillAmnt,
Table1.DateRec,
Table2.InstallationFee,
Table2.DatePaid,
FROM Table1 INNER JOIN Table2 ON Table1.ClientID = Table2.ClientID
WHERE Table1.DateRec=#01/01/2016# and Table2.DatePaid=#01/01/2016#

Patulong naman guys... any workaround? di na kaya ng utak ko eh, hehehe... Thanks in advance sa tutulong!

- - - Updated - - -

Up ko lang query ko...

 

[maskio]

UNION gamitin mo

SELECT clientId, billAmt, dateRec, '' `datePaid` FROM TABLE1 WHERE dateRec = 'yourdatehere'
UNION
SELECT clientId, installationFee, '', datePaid FROM TABLE2 WHERE datePaid = 'yourdatehere';

ididikit ng inner join ang table mo sa gilid, ididikit ng union ang table mo sa baba.
inner join (horizontal)
union (vertical) -> pero need mo na the same column count ang first query sa second query.

 

[jocno1212]

UNION gamitin mo

SELECT clientId, billAmt, dateRec, '' `datePaid` FROM TABLE1 WHERE dateRec = 'yourdatehere'
UNION
SELECT clientId, installationFee, '', datePaid FROM TABLE2 WHERE datePaid = 'yourdatehere';

ididikit ng inner join ang table mo sa gilid, ididikit ng union ang table mo sa baba.
inner join (horizontal)
union (vertical) -> pero need mo na the same column count ang first query sa second query.

Thanks boss. Laking tulong... Thanks so much!!!