On Fri, 3 Sep 2004 15:47:26 -0400, wrote:
A. Any record in tbl_development can be associated with up to 8 URLs that
represent virtual tours of the dwelling types in that particular
development.
B. tbl_urldetails is a table acting as a master list of the virtual
tours you have ready to use.
Hi,
I have a main query which can reads a record tbl_development
This has a varying number of the following fields
IDurl1
IDurl2
...
IDurln
The fields contain indexes into another table tbl_urldetails where each record
contains details
about each URL eg hyperlink, description
Currently I
You say you have a table that changes how many columns it has? Please post
the results of:
SHOW CREATE TABLE tbl_developent\G
SHOW CREATE TABLE tbl_urldetails\G
so I can see it too. :-D
Actually, it sounds like you have a normalization problem. Posting those
two table structures will give
You will normally get better responses if you always CC the list in each
of your replies (unless you are intentionally going off-list).
Yes, it sounds like you are talking about a relationship to me, too. If
the we had your existing table structures in front of us we could help you
to
I don't understand what do you mean by trim out the irrelevant? If
certain columns aren't important then why are they in your tables? I don't
need any data, only the structures. You do know that you don't need to
post to an actual NG to get your message to the list, right?. You only
need
: Friday, September 03, 2004 1:06 PM
Subject: Re: Understanding Joins : Baffled
I don't understand what do you mean by trim out the irrelevant? If
certain columns aren't important then why are they in your tables? I don't
need any data, only the structures. You do know that you don't need
On Fri, 3 Sep 2004 13:06:45 -0400, wrote:
I don't understand what do you mean by trim out the irrelevant? If
certain columns aren't important then why are they in your tables? I don't
need any data, only the structures. You do know that you don't need to
post to an actual NG to get your
Let me see if I can summarize what I know so far:
A. Any record in tbl_development can be associated with up to 8 URLs that
represent virtual tours of the dwelling types in that particular
development.
B. tbl_urldetails is a table acting as a master list of the virtual
tours you have ready to
