View Single Post
  #1  
Old April 28th, 2004, 05:18 AM
jj
external usenet poster
 
Posts: n/a
Default How do you do an inner join...

on just a PART of a field?

Here's the structure so far:

Access 2000, 3 tables (Furniture, Titles, Descriptions), no joins.

Here's the design & some sample data:

Table: Furniture
--------------------------------------------------------------------------
Field: Title Field: Description
---------------------- -------------------------------------------
Black Satin Sheet Bought at JC Penney's for $20
Old English Brass Lamp Lightbulb broken, needs replacing
Edwardian Chair White with one broken leg
Georgian Dresser Needs polishing with $20 polish




Table: Titles
----------------------
Field: TitlesData
----------------------
Lamp
Satin Sheet
Edwardian Chair




Table: Descriptions
----------------------
Field: DescData
----------------------
$20
broken


Basically the Furniture Table is a list of all possible Titles and
Descriptions, and the other two tables include stuff that I want to DELETE
from all entries in the Furniture Table. I've written a procedure that loops
through all of the records in the Titles Table looking for entries, using
LIKE in a SELECT statement, and then goes & does the same for the
Descriptions table -- which works, but it's very slow.

I can't seem to figure out how to join the tables in a sensible way,
because the records in both the Titles and the Descriptions tables
may or may not describe the entire record in the Furniture table,
and if it's not the whole record, it doesn't always start in the
same place. So, I need something that's dynamic for each
record or some sort of link with part of the table.

Does anyone else have any bright ideas?

Thanks in advance,

JJ