Sherif - 9:38 am on Aug 5, 2010 (gmt 0)

Hey Guys....

Until now i didn't get any response related to my issue, and until now i couldn't find any answer to my problem.

I checked the syntax multiple times, and was able to optimize it. The output as far as i am concerned is correct in terms of correctly joining the results between the 2 tables.

The main problem that i am facing, if i have data in the invoices table, and no values in the payment table related to that data, then the values of the columns that are being joined (building_no, apartment_no, and invoice_id) do not appear, while the other data in the other columns of the same row appear.

Does anyone have any solution to this problem. (I need the data to appear since these are the unique numbers of the row itself, so i need it to pass the information to another page so that we can later associate the payments with these values).

I tried the the

LEFT JOIN

& the

LEFT OUTER JOIN

and i get the same results (output)

Your Help will be much appreciated.

Thanks a lot for your support in advance.

Sincerely,
Sherif