Hi Dave, thanks for the quick reply. My problem is a,b,c,d and e are the
most efficient
way to define they key. Because of the way the data is generated, they
are guaranteed to
always be unique at the row level. Also I need to sometimes query just
by a or b or c etc.
I could add an auto increment column, but this is introducing some
redundancy to each
row. Still, if it is the only way around the problem, it may be the best
solution.
Another idea I had was to use views to construct a virtual table all
the column
joins I need. Will Maypole display table views?
Regards,
Kim
Dave Howorth wrote:
On Tue, 2006-01-03 at 10:03 +1100, Kim Ryan wrote:
Thanks for all your help. I am still having trouble getting the result I
need.
I will describe the problem slightly differently, perhaps it does not
fit into
the 'has_a' approach. Can I define my own query and get maypole to
display the results?
I have a table x with key columns a,b,c,d,e
I have a table y with key columns a,b,c,d,e, plus another non key column f
I would like to display all the columns in x, PLUS the column f from table y
I need to perform a join from table x to y to achieve this.
I guess you're trying to simplify the problem for purpose of
illustration - as you've described it here couldn't you just drop table
x altogether?
I'd second Peter Speltz' advice. If at all possible, just add a
[autoincrement?] single primary key column, make a UNIQUE a,b,c,d,e
constraint and life will go much more smoothly, I think.
Cheers, Dave
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Maypole-users mailing list
Maypole-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/maypole-users
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Maypole-users mailing list
Maypole-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/maypole-users
