Re: Using table field in query constraints

#1

use an embedded SQL statement and the IN keyword, i.e., SELECT * FROM
Table WHERE sal IN (SELECT [Second_Table].[value] FROM
[Second_Table]). this will get everything from the first table where
the value matches something in the value field of the second table.

tom

steven.krizanovic (AT) cba (DOT) com.au (Steve) wrote in message news:<198dc354.0308131558.1ac4a5af (AT) posting (DOT) google.com>...

Quote:

Hi,

I am using Access 97. I have two tables, one contains employee
information, including salary information. the second contains
constrains to be used in a query to get a cross section of
information. I know you can write a SQL with the constrain 'WHERE sal
= [second_Table].[value]'. eg [value] = '50000'

My question is how can i include the whole constraint in the
[second_table].[value] eg [value] = '>=50000' so some how the SQL
looks like 'WHERE sal is [second_table].[value] ('IS' does not work).
so in theory, the WHERE statement is exactly the same as the first?

Thanks in advance

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Using table field in query constraints

comp.database.ms-access comp.database.ms-access

Re: Using table field in query constraints - 08-19-2003 , 11:35 PM