Skip to Content
0
Former Member
Sep 14, 2007 at 05:47 AM

JOINS

249 Views

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