var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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!!!!
Re: SQL troubles please help....
put your fields you wanna select here seperated with a , so :
field1 , field2 , field3
LEFT JOIN developmentpictures ON Development.[KinderNumber] =developmentpictures.[KinderNum]