Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003

    Unanswered: SQL troubles please help....

    I have a form that through VB code loads information from 2 tables in a WEB or Paging style format..

    Basically one table is nothing but pictures with basic information and there are various pictures for each "ID" number because of revisions to te product design.

    the other table is a list of information about each "ID" product w/ ID being my FK and no duplicates of this....

    My current SQL is omitting information.....?

    "select * FROM Development, developmentpictures WHERE Development.[KinderNumber] = developmentpictures.[KinderNum]"

    What I want with my form is to return everypicture and next to the picture I want the information from the information table to populate about that ID that pertains to that picture........

    hopefully this makes sense and Please help!!!!

  2. #2
    Join Date
    Jul 2003
    Amsterdam, Nederland

    Re: SQL troubles please help....

    put your fields you wanna select here seperated with a , so :
    field1 , field2 , field3

    FROM Development
    LEFT JOIN developmentpictures ON Development.[KinderNumber] =developmentpictures.[KinderNum]

Posting Permissions

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