- Messages
- 884
- Reaction score
- 5
- Points
- 28
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
Gusto ko sana maging ganito output ng QUERY ko
Paano ba yung tamang SQL code nito,
Ano po ba mali dito?
Patulong naman guys... any workaround? di na kaya ng utak ko eh, hehehe... Thanks in advance sa tutulong!
- - - Updated - - -
Up ko lang query 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...