Query Help

[jimmy1981]

Hi,

I am new to SQL queries and was after some help.

I have a database with fields ID, Line, StationName, StationNumber and Variant.

I need to:
Find the line and station from the database (from selections made from user)
This will show what variants the station has attached to it.

I then need to use these variants to search the database against the Line to show all StationNames with the same Variant and Line

Seems simple but I'm not sure how i'd start, would I need multiple queries?

Also, this query will return duplicate stationnames which is expected but is there a way of having the query show no duplicates?

Thanks,
Jimmy

 

[jmcilhinney]

So, what exactly is the user entering?