The perl code in this case isn't really relevant as this is a SQL issue. You should confirm that you are querying the correct table, and that the columns you listed exist in that table.
Try running the SQL in Query Analyzer if you have access to a windows machine.
Comment on Re: Can get values from db but cannot get related values from the relevant lookup table