Need to enter SELECT statement into CR11 for VB.Net during designtime

Hi all,

I'm using CR11 with VB.net and MySQL and need to pass a recordset similar to the following into the report:

Code:

---

"SELECT Sales.InvoiceNo,
Product.ProductName, StaffPurchase.UName, StaffVerify.UName FROM Sales
LEFT JOIN Product ON Sales.ProductID = Product.UID LEFT JOIN StaffProfile
StaffPurchase ON Sales.PurchaseID = StaffPurchase.UID LEFT JOIN
StaffProfile StaffVerify ON Sales.VerifyID = StaffVerify.UID ORDER BY
InvoiceNo"

---

The Sales database (MySQL) has (among others) the following fields:
InvoiceNo VARCHAR(12)
ProductID VARCHAR(10)
PurchaseID VARCHAR(10)
VerifyID VARCHAR(10)

The Product database (MySQL) has (among others) the following fields:
UID VARCHAR(10)
ProductName VARCHAR(50)

The StaffProfile database (MySQL) has (among others) the following fields:
UID VARCHAR(10)
UName VARCHAR(50)

- how do I enter the SELECT statement above into the Database Expert in CR11 during design time, so I can drag/drop fields such as StaffPurchase.UName and StaffVerify.UName into the *.rpt?
- would using aliases help?