SQL query to get data from many relating tables in MS Access

gowrisub has asked for the wisdom of the Perl Monks concerning the following question:

Hi All, I have some 5 tables in MS Access having Dept_Det, Trans_Det:-(Trans_Code,Tran_Desc) UnitFile_Det:-(Unit_Type has kg,lit,meter, gallon), Item_Det :-(Code,Qty, Item_Unit), Stock_Reg_Code:-(Stk_Qty,Stk_Level-Max,Min) each having variables like respective codes and descriptions. I want to generate a report consisting of the Trans No,Dept No with Desc,Item_Code with Desc,Qty req with unit Desc and Stock with Stk_Level. Please let me know how to write this in Perl using queries.

Comment on SQL query to get data from many relating tables in MS Access

Replies are listed 'Best First'.
Re: SQL query to get data from many relating tables in MS Access by Corion (Patriarch) on Oct 14, 2008 at 09:17 UTC
See DBI and DBD::ODBC, which is the driver for ODBC-compatible databases.	[reply]
Re: SQL query to get data from many relating tables in MS Access by Anonymous Monk on Oct 14, 2008 at 09:14 UTC
Why?	[reply]