Hi,
Can anybody please explain the following, if possible with an example:
1. None of the fields in the table on the right can apear in the WHERE conditions of the LEFT OUTER JOIN.
2. SELECT <fieldlist> INTO <target>
FROM <dbtab1> AS <alias1>
INNER JOIN <dbtab2> AS <alias2>
ON <alaias1><dbtab1-field1> = <alials2><dbtab2-field1>.
Please explain the about code specially the alaising involved.
Regards,
Dhiraj Mehta