[Perl] multi table query

dsheller · 11-03-2005, 02:35 AM

I have a query that polls multiple tables, and some of the fields have the same names in these tables ex:

table 1
field1, field2, field3

table2
field1, field34, field3

They match at field1 and field 3. So my problem is in retrieving the data correctly... I suppose I could do multiple queries to keep it all straight but it would be easier for one. Any ideas will be great!

vireshwali · 11-03-2005, 03:38 AM

select <filed names> from <table1>,<table2>....

dsheller · 11-03-2005, 03:40 AM

My problem isn't with the query, rather it is with how do I access the data AFTER I run the query... seeing as some of the field names are the same.

vireshwali · 11-03-2005, 03:42 AM

try this.....
select table1.field1 as f1, table1.field2 as f2, table2.field1 as f3, table2.field2 as f4 from table1,table2........

dsheller · 11-03-2005, 05:32 AM

Thanks for that. I tried it, but in the end I figured that renaming the fields so they don't overlap would be the easiest solution.