Hello everyone. I have many tables in my database out of which I have made two queries on some of the tables
Results of the two queries are like:
1st query
lid mref tearned
1 2 5
2 4 0
3 9 3
4 5 8
5 6 0
2nd query
lid amount
2 5
3 4
But I want the resultant of these two queries to be like below
lid mref tearned amount
1 2 5 0
2 4 0 5
3 9 3 4
4 5 8 0
5 6 0 0
can someone please help me? how can I join the result of these two queries based on lid.