Board index » jbuilder » Append two or more datasets

Append two or more datasets


2005-07-05 04:48:20 AM
jbuilder17
Hi,
I'm just wondering if it is possible to append one dataset(querydataset) to
another, so the appended dataset has the rows coming from two datasets.
Thanks,
Frank
 
 

Re:Append two or more datasets

Why not create a dataset query that combines data from both datasets or tables.....such as....
dataset1 = Select * from Customer;
Dataset2 = Select * from Invoices
DatasetCombined = Select customer.name, customer.address, invoices.inv_number from
customer, invoices where customer.act_number = Invoices.Act_number;
Bob