|
-
Jun 21st, 2008, 02:28 AM
#1
Thread Starter
New Member
Outer Join Support
I am using MS Access database and the following query generate support error in crystal report.
SELECT
Item.`Item_Code`, Item.`Item_Name`, Item.`OP_QTY`, Item.`OP_Rate`,
Stock.`voucher_no`, Stock.`voucher_date`, Stock.`quantity`, Stock.`rate`, Stock.`DC`,
Users.`User_Name`,
Company.`Comp_Name`, Company.`Address`
FROM
((`Stock` Stock RIGHT OUTER JOIN `Item` Item ON Stock.`item_id` = Item.`Item_Code`) INNER JOIN `Company` Company ON Stock.`comp_id` = Company.`Reg_No`) INNER JOIN `Users` Users ON Stock.`user_id` = Users.`User_Id`
ORDER BY
Item.`Item_Code` ASC
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|