3 tables - force entries for first 2 tables to be outputted and then any values from table 3

[hsduk101]

All,

I have 3 tables

Table 1 - Contains single column called routes: i.e. A,B,C,D,E,F etc


Table 2 - Contains single column called Job Code i.e. 1,2,3,4 etc

Table 3- contains the values, if there is any for the above 2 tables. it has 3 columns: Route, Job Code, and Value i.e A , 2, 345

There is a hierarchy to these tables. Each Route, will have every single job code

I want to write a query combining all 3 tables. However even though table 3 might not have any entries for any of the combinations for Tables 1 and 2. I want the query to force all combinations of tables 1 and 2 to be outputted and then a 0 for any nulls

Help required many thanks

[ranman256]

in a query, bring in Tbl1 & Tbl2
do not join them
bring down the fields from both
add extra field : 0

run query

[ssanfu]

in a query, bring in Tbl1 & Tbl2
do not join them

This is called a Cartesian Join (if you want to read about it http://www.dba-oracle.com/t_garmany_...cross_join.htm )