Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Parameters in Subqueries - Visual C# 2008 EE
Hi all, I am writing a SQL query in the TableAdapter Query Configuration Wizard and it includes a Subquery. I have some parameters in my main query, and would like to have a parameter in the Subquery also. My query works up until the point where I add a parameter to the Subquery, when it stops...- chipboard
- Thread
- Replies: 4
- Forum: C# (C sharp): Microsoft
-
SQL: Joining different look-up IDs in a record to the same secondary t
Hi all, So I'm familiar with the technique of using SQL to return the text values in an external table which are linked to my main table using Lookup fields as follows: SELECT MainTable.RecordId, SecondTable.RecordName FROM MainTable INNER JOIN SecondTable ON MainTable.SecondTableId =...- chipboard
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
-
Combining SQL SELECT statements
Hi all - first post and I hope I have the right section of the forum... I have 3 seperate SELECT statements that I would like to combine into one. I have four Tables called "Client", "Letters", "Agreement" and "Rate", which are linked in that order via ID values. Rate also links to a number of...- chipboard
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
