I&#039;m trying to query for description & display an image of an item. I have 3 tables: iattr, aid, & image. I want to display the images whether if the image exists or not.. I get this error:<BR>"An explicit JOIN must be the only element in a FROM clause"<BR>Can someone please tell me what I do wrong?? Thanks!<BR><BR>str="SELECT DISTINCT iattr.description, aid.quantity, image.imagepath FROM iattr, aid LEFT OUTER JOIN image on (image.itemnum=aid.itemnum) WHERE (aid.itemnum=&#039;" & ItemNumber & "&#039;) AND (aid.itemnum=iattr.itemnum) "