Source = "select Development.[Kinde

[BigFizil]

Source = "select Development.[KinderNumber],Development.[Date],Development.[Client],Development.[MFG],Development.[Fixture],Development.[Dimensions (HxWxD)],Development.[MFG Price],Development.[Item Number], dp.[Image], dp.[Revision_ Letter] FROM developmentpictures dp, Development WHERE dp.[KinderNum]= Development.[KinderNumber] AND dp.[Revision_ Letter] IN(select max([Revision_ Letter]) from developmentpictures where kindernum = dp.kindernum)


here is my SQL statement that works perfect....although when I add a LEFT or RIGHT JOIN it wont work?? Please help!!!

 

[r937]

add?

you have a "table list" join in there right now, it might be better to rewrite that with JOIN syntax first

then when you add a third table, you have to parenthesize the joins

e.g.

from (
tableA join tableB
on tableA.id = tableB.A_id
)
join tableC
on tableB.id = tableC.B_id


rudy