KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a table (foo) with a large number of several records and I only want to select those that are like one of the records in a field in another table (foo2) If I do a SELECT query with an inner join SELECT pst_qty AS [QTY] ,[MFGPN] ,[mfg_name] AS [MANUFACTURER] ,description ,sup_id FROM [foo] INNER JOIN [foo2] ON [foo].[MFGPN] = [foo2].TestString afaik I would only get records where foo.field1=foo2.field1. I can't seem to use ON foo.field1 LIKE foo2.field2 to select records like the fields in foo2. How would I go about selecting the records that are like the records from a column in a different table?
Tags (comma-separated)
Save Edits
Cancel