Newbie --- JOINS

Newbie --- JOINS

am 08.04.2009 14:17:00 von BobTheBowler

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.

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:

The Professional version does not have this message