Hi David
Thanks your response. I'm using Lasso but that's largely unimportant because
I still need to get the data returned in a way that I can use it. I should
not have said "displaying" - I meant "returning".
I need to return only one column from table A (there could be up to 14
records). I need to return the data in such a way that I can display the
result horizontally, as column headings, with the data in table C still
being correctly related to them.
I need to return two columns from table B (there could be an unlimited
number of records). I need to show this data vertically, with the first of
the two columns as row headings. And they need to also correctly relate to
the data in table C.
I then need to return one column from table C (there could be an unlimited
number of records) so that I can display them in their correct places as
they relate to tables A and B.
Table C has two foreign keys that relate to tables A and B respectively.
I need to display something like this:
A B C D E F G
1 1 X X
2 2 X
3 3 X
4 4
The A, B, C data comes from table A, the numbers from table B and the Xs
from table C.
Sorry, I'm probably not explaining myself very well. Can you suggest
anything?
Many thanks
--
Aeon McNulty
On 23/7/04 5:39 pm, "David Brieck Jr." <[EMAIL PROTECTED]> wrote:
> On Fri, 23 Jul 2004 17:30:21 +0100, Aeon McNulty
> <[EMAIL PROTECTED]> wrote:
>> Hi, I hope someone on the list can help me.
>>
>> Is there an easy and straightforward way way of displaying the data from
>> three tables in a spreadsheet like format using MySQL 4.0?
>>
>> Table A has the column headings
>> Table B has the row headings
>> Table C is a line items file than cross relates the two
>>
>> Many thanks
>>
>>
> What language are you using? MySQL provides data, not an end user
> display. If this just a one time thing you might try using MySQLFront,
> it will let you save a result set to CSV.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
