Prev: From temporary table to master table and then join this in junctio
Next: Question About Missing Data
From: John W. Vinson on 8 Apr 2010 11:52
On Thu, 8 Apr 2010 06:18:21 -0700 (PDT), moso97ad <nyhusevej28(a)gmail.com>
wrote:

>I now want to join the data in a junction table:
>
>[tbl_contractdetails]
>contract_detail_id
>contract_id
>product_id

You can't create a (useful) junction table from *just* the contract and
product tables. The whole point of a junction table is that a record only
exists when there is in fact a real-life connection between a particular
Contract and a particular Product.

You could run a "Cartesian join" query adding every possible combination of
contracts and products, but that would be pointless, since it would imply that
every contract in fact involves every single product; if you had 1000
contracts and 500 products, you'ld get 500,000 rows.

Do any of your spreadsheets provide a logical link between products and
contracts?
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: From temporary table to master table and then join this in junctio
Next: Question About Missing Data