Re: Multiple tables with same field name

["paross1" <webforumsuser@xxxxxxxxxxxxxx>]

Alias your colunms....

 SELECT
 request.ID, request.FirstName, request.LastName, 
 request.sem, request.year, request.banner,
 Week1.ID AS wk1_ID, Week1.Total AS wk1_total,
 Week2.ID AS wk2_ID, Week2.Total AS wk2_total,
 Week3.ID AS wk3_ID, Week3.Total AS wk3_total,
 Week4.ID AS wk4_ID, Week4.Total AS wk4_total....
 .....etc.

 They will now have different names in the output.

 Phil