I'm trying to write an MS Access query like this:
SELECT Table1.Title
FROM Table1, Table2
WHERE Table1.Title = Table2.Title
The problem is that the Title fields' values may not be exactly equal. Table2.Title
may have additional text in parentheses at the end. For example:
Table1.Title = "The cow jumped over the moon"
Table2.Title = "The cow jumped over the moon (really)"
I thought of using the LIKE operator, but it appears that LIKE only works when
comparing a field and a string, not two fields. If I'm wrong, please tell me the
syntax.
Any other suggestions on how to do this query?
Thanks.
-David
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]