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 what 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
| Thread |
|---|
| • Newbie and JOINS | BobSharp | 7 Apr |
