Can you use a left outer join if you&#039;re pulling data from multiple tables? For ex. I want to display some data from 3 tables whether there is an image for it or not:<BR><BR>str="SELECT DISTINCT item, description, custnum FROM acoitem, iattr, aid left outer join image on (image_item=item) WHERE (aid.item=&#039;" & ItemNum & "&#039;) and (aid.item=acoitem.item) and (aid.item=iattr.item) "<BR><BR>I get this error:<BR>An explicit JOIN must be the only element in a FROM clause