Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Unanswered: Using Access Query in SQL

    I have an Access database with tables,queries, forms etc. I would like to get some data out of a query.

    This is my initial cut:

    SELECT RECIPE.TITLE, INGREDNT.NAME,
    ShowUnitRecs.STRING, QUANTITY.MAX_QTY
    FROM RECIPE, INGREDNT, QUANTITY,
    WHERE
    RECIPE.RECIPE = QUANTITY.RECIPE AND
    INGREDNT.INGREDIENT = QUANTITY.ITEM AND
    QUANTITY.ITEM = ShowUnitRecs.ITEM AND
    RECIPE.RECIPE = '000001';

    Where RECIPE, INGREDNT and QUANTITY are tables and
    ShowUnitRecs is a Query.

    Without ShowUnitRecs, the select works fine.

    Thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you need to add ShowUnitRecs to the FROM clause

    rudy
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Aug 2003
    Posts
    2
    Originally posted by r937
    you need to add ShowUnitRecs to the FROM clause

    rudy
    Thanks, that worked.

Posting Permissions

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