Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jimmy1981
Starting Member
8 Posts |
 Posted - 2011-12-29 : 07:57:57
|
| 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 LineSeems 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 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Jimmy1981
Starting Member
8 Posts |
Posted - 2011-12-29 : 09:18:45
|
| what about how it would be done if the line was TEST and station was TEST2, say we ignore how to determine what they select?I will be able to sort that bit using VB.Net |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Query Help