NageshKuppuraj1
2 years agoQrew Member
Simple table Join question from a QB newbie
Hi,
I am trying to join two tables - let's say Customer and Order tables. Customer->Order has 1-M relationship. The primary key for the Customer is Customerid and for the order table is Orderid. 1 customer can have multiple orders. I want to join the two tables and display all the attributes in one table. for ex: in SQL I can do something like: Select * from customer, order where order.customerid = customer.customerid . I am not sure how to go about doing this in QB. Any help appreciated. Thanks
------------------------------
Nagesh Kuppuraju
------------------------------