HELP: I am desperate(view problems)

Hi!

I have the following problem.

I have three tables which looks like this:

		account:
		actid


		..

		..

		..

	    /		   \
	  /		     \
	/		       \
usage:				budget:
actid				actid
transdate			transdate
amount				amount

In this model there is a budget transaction the 1st in every month.

Now I want to create a view which should look like this:

view:
actid transdate usageamount budgetamount

example
account:
actid 1014

usage:

actid 		1014
transdate 	19970303
amount		800

actid 		1014
transdate 	19970305
amount		800

budget:
actid 		1014
transdate 	19970103
amount		1900

the view
actid		transdate	usage	budget
1014		19970101	    0	  1900
1014		19970303	  800	     0
1014		19970305	  800	     0

If there isn't any usage or a any budget for a specific date, there has to be a zero.

My problem is, what ever I do, I end up with the Cartesian product.

HEEEELLLLPPPPPPP!!!!!!!

-- 
Casper Thrane
System developer
Benau A/S