At 07:23 AM 12/03/2006, you wrote:

>Is it possible to perform a select where the data rows returned are
>different fields from different tables?
>
>I want to do like a transaction activity report that would have data from
>two tables - a billing table and a payment table.
>
>So I'll slightly simplify my situation in this example:
>
>BILLING
>---------
>BILLINGID
>BILLINGDATE
>BILLINGCODE
>BILLINGAMOUNT
>
>PAYMENT
>--------
>PAYMENTID
>PAYMENTDATE
>PAYMENTCODE
>PAYMENTAMOUNT
>
>So I'd like results something like:
>
>BILL1,JAN1,BILLCODE1,100
>PAY1,JAN2,PAYCODE1,50
>PAY2,JAN3,PAYCODE1,50
>BILL2,FEB1,BILLCODE1,100
>PAY3,FEB2,PAYCODE1,50
>
>And so forth...is such a thing possible?

Are the tables meant to be related to each other in any way? or are
you just interested in "all of the billings and all of the payments,
arranged in ascending order by date" ?

./heLen