Allow 2 coumns with same name

[Reez]

Hey all,

Can I create a query from a table and put 2 columns with the same name or do I have to use "AS" to keep one column same name and the second give it an alias name but it will remain connected to the same column?

Thank you

 

[Ron_dK]

The fieldname of the second "column" should differ from the first, but why would you create two fields in one query giving the same data ?

 

[Reez]

I changed the name, but the data is not appearing in the query.
see, what I'm trying to do is this:
I have a table (location ID, location latitude)
another table (link ID, path length)

I want to create a query such that every 2 locations are connected with 1 link (location1ID, location2ID, linkID, pathlength)

and i did this in the query design, only the query is still empty no data. Should I do something else, like am i missing something?

 

[Ron_dK]

Could you post your query.

 

[Reez]

I've tried that before, it wouldnt work? do u have an email i can send it to u to look at it, coz its driving me crazy,

 

[Ron_dK]

Don't email me or anyone. We are here to help, but want to make the solution avialable to anyone else who is encounting sort of the same problem.
Back to the query :
Go to your query in design mode, and click SQL view.
Now simply copy/paste that in your post.

Hth

 

[Reez]

Ok, this is it

SELECT [P2P MW Link Information].SP_ID, [P2P MW Link Information].Link_ID, Sites.Site_ID AS Site1_ID, Sites.Site_ID AS Site2_ID, Antenna.Ant_ID AS Ant1_ID, Antenna.Ant_ID AS Ant2_ID, Sites.Site_Latitude AS Site1_Latitude, Sites.Site_Longitude AS Site1_Longitude, Sites.Site_Latitude AS Site2_Latitude, Sites.Site_Longitude AS Site2_Longitude, [P2P MW Link Information].Polarization, [P2P MW Link Information].[Band], [Frequency Sub Channel].[TX_Center_Freq(MHz)], [Frequency Sub Channel].[RX_Center_Freq(MHz)Channel_Bandwidth(MHz)]
FROM [P2P MW Link Information], [Frequency Sub Channel], Antenna INNER JOIN [GSM Network Parameter] ON Antenna.Ant_ID = [GSM Network Parameter].Ant_ID, [Fixed Wireless Access Subscriber Equipment Data] INNER JOIN Sites ON [Fixed Wireless Access Subscriber Equipment Data].Site_ID = Sites.Site_ID;

 

[Jemmo]

Check your syntax.

Where is the 'WHERE' clause?