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
.
|