Newbie --- JOINS

------=_NextPart_000_13B6_01C9B84C.4D1225B0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Picture does not seem to have been carried in the message,  posts with atta=
chment did not seem to get through either.    
So  hope the link works.


Below is the ER diagram in an exercise I am trying to do. 
http://www.probowluk.co.uk/images/er=5FECA=5F001.jpg 

It's been going well so far,  and several ColdFusion pages written already.=
 

Need to do one for a  Purchase Order Report   for  ... 
 -   given  SupplierCode 
 -   given StartDate and EndDate of Orders  

My problem is in the CFquery  -   understanding what JOINS to use and in wh=
at order to use them. 

(it is a MyISAM database  ---  no constraints)



-- 
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 12908 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message

------=_NextPart_000_13B6_01C9B84C.4D1225B0--