stubailey007
New member
- Local time
- Today, 21:45
- Joined
- Jun 14, 2005
- Messages
- 9
Hi,
I am quite new to SQL Server and really need help running an SQL Statement.
I am trying to select all records from one table and only those from another table which match, however I need to filter the second table first based on a user input. Anyone got any ideas on how I can do this?
The basic access (Jet backend) query would be something along the lines of "SELECT ALL * FROM tbl1 LEFT OUTER JOIN (SELECT * FROM tbl2 WHERE Col=" & Form Reference & ") as qry1 on tbl1.ID = qry1.ID" (off the top of my head)
TIA
Stu
I am quite new to SQL Server and really need help running an SQL Statement.
I am trying to select all records from one table and only those from another table which match, however I need to filter the second table first based on a user input. Anyone got any ideas on how I can do this?
The basic access (Jet backend) query would be something along the lines of "SELECT ALL * FROM tbl1 LEFT OUTER JOIN (SELECT * FROM tbl2 WHERE Col=" & Form Reference & ") as qry1 on tbl1.ID = qry1.ID" (off the top of my head)
TIA
Stu
