Unanswered: Query: Use value of field as anothers criteria
I am writing a query and I need to use one of the fields as the criteria. So its like
SELECT a.field1, a.field2, b.field1, b.field2 FROM a, b WHERE b.field1 LIKE a.field1
See, I need to only retrieve those values for when b.field1 is like a.field1. The problem is that the one field is a web address (http://www....) and the other the end part of the url (how_to_create_order.html). So, a link is not possible (right?). I can compare the two with strings and * but I need a query to be able to this for many records.
I use the Design View for queres. Here's a SQL that not working.:
SELECT Table.Field1, Table.Field2, Table.Field3, Table.Field4, Table.Field5, Table.Field6, fs.Filename
FROM [Table], fs
WHERE (((fs.Filename) Like "*[Table]![Field6]*"));