Sherif - 12:48 pm on Aug 8, 2010 (gmt 0)
In the SQL syntax, there is a FULL JOIN command that joins the tables together similar to the left join + right join, but this FULL JOIN syntax doesn't exist in MySQL So i have to use both to get the same effect, but in order to avoid the duplicates that will arrise because of the join using the UNION ALL command, we use the is null in the seccond query.
The script works really well in obtaining the results that i want.
The problem that i am currently facing is that, if there is no match in the left join, the data is retrieved from the table in the left, but the values of the Joined Columns are not displayed.
Is there a command that i should use to output the values of the JOINED COLUMNS even if there is no actual join / match?
This is a serious issue, since i need to use these values as they are the unique key that i will use later on to associated data to it in the other table using forms.
Thanks in advance for your support.