left outer join

  • Thread starter Thread starter wk6pack
  • Start date Start date
W

wk6pack

Hi,

I would like to use a generic sql statement for the join property. Is this
possible?

select a.name, b.name
from table1 a, table2 b
where a.locid =+ b.locid

instead of:
select a.name, b.name
from table1 as a left join table2 as b on a.locid = b.locid

thanks,
Will
 
You can do that with an Inner Join, but not Outer. Before the ANSI-92
standard, database vendors invented their own syntax for specifying an outer
join in the WHERE clause, and most used something similar to what you
propose. (Transact-SQL still supports the obsolete *= comparator.) Access
(JET) supports only the ANSI-Standard syntax for outer joins.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411
 
Back
Top