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 [email protected] https://lists.sourceforge.net/lists/listinfo/maypole-users
