syntax error in from statement

Results 1 to 2 of 2

Thread: syntax error in from statement

  1. #1
    Join Date
    Dec 1969

    Default syntax error in from statement

    I am trying to update information in three tables of an Access Database. Keep getting syntax error in from clause.<BR>Here is the response.write of my sql statement. Any help would be appreciated!<BR><BR>SELECT o.UserName, o.UserPassword,pi.[Property Address], pi.City, pi.State, pi.ZipCode, pi.ListPrice, pi.Taxes, pi.YearBuilt, pi.Occupied, pi.Use, pi.Units, pi.Bedrooms, pi.Baths, pd.SquareFeet, pd.Levels, pd.Exterior, pd.Basement, pd.Parking, pd.Heat, pd.HeatingFuel, pd.AC, pd.Fireplaces, pd.Water, pd.Sewer, pd.Electric, pd.Refrigerator, pd.Oven, pd.Microwave, pd.Dishwasher, pd.Disposal, pd.Washer, pd.Dryer, pd.CreativeFinancing, pd.Remarks <BR>FROM OwnerInfo AS o Join PropertyInfo AS pi <BR>ON o.UserID = pi.OwnerID Join PropertyDetails AS pd <BR>ON pi.DetailsID = pd.DetailsID <BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80040e14&#039; <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. <BR><BR>/Pages/photo_sales.asp, line 66 <BR>

  2. #2
    Medieval Dude Guest

    Default RE: syntax error in from statement

    You don&#039;t use the word AS to alias table names. You simply put the alias directly after the table name. Example:<BR>FROM OwnerInfo o Join PropertyInfo pi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts