A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do you do an inner join...



 
 
Thread Tools Display Modes
  #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



  #2  
Old April 28th, 2004, 12:26 PM
Gerald Stanley
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:48 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.