If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
How do you do an inner join...
The syntax is
FROM Table1 INNER JOIN Table2 ON Table1.columnA LIKE "*" & Table2.columnB & "*" Hope This Helps Gerald Stanley MCSD -----Original Message----- 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 ---------------------- =20 ------------------------------------------- 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 . |
Thread Tools | |
Display Modes | |
|
|