Join tables with same name fields

[teqtaq]

When 3 tables linked and each has LN and FN in it - how do I take care of EmplID:[LN]&", "&[FN] and MngrID:[LN]&", "&[FN] and than HiringMngrID:[LN]&", "&[FN]

It seems like if I am leaving those fields in the query and joining them on the Report level - I am getting blank fields. Query works fine because every LN FN has a table assocoation. But when on Report level - it gets confused? Please, advise.

 

[Golom]

Give them different aliases in the SQL

Select Emplid.LN As ELN, MngrID.LN As MLN, etc..

Usually something like

Select Emplid.LN, MngrID.LN, etc..

ends up with fieldnames "Emplid.LN, MngrID.LN" in the generated table.

 

[fneily]

More importantly, why do you have 3 tables with FN and LN? This indicates your tables are not normalized. See:
Fundamentals of Relational Database Design

http://r937.com/relational.html

FN and LN should be stored in only one table. If your tables aren't normalized, your database probably has more problems.

 

[teqtaq]

Thanks to all.

Unfortunatelly I am the only IT in HR so tables were built for us by somebody and I am not on a position to say anything. I would though