Hi Kim, You can create a temporary table by using a table alias. The temporary table will only be accessable by the current connection. Any other connection will not be able to use it.
If you want to make a table which can be used by several connections (f.e for a join) you could create a HEAP table which remains completely in the memory, but all data goes when the server crashes or powered off, the structure remains. Best regards Nils Valentin Tokyo/Japan 2003年 8月 13日 水曜日 15:21、あなたは書きました: > G'day Nils > > > just send a reply a minute ago. I got it now. You want to change the way > > the data is presented at the screen and thats a different issue. You > > would have to make this in your apllication, not with mysql itself I > > believe. You basically want the DISTINCT function within the JOINS - but > > only applied for a certain column. > > Thats not possibe yet I believe. > > > Ah, ok, now where getting somewhere:) > > I had already tried Distinct but as you say, it can't really work with the > joins I have currently. I'm looking to see if it's possible to simply set > the displayed columns (I'm using PHP) of the redundant stuff to "". > > Which leads me to another question. I've never used temporary tables. Would > it be possible for me to do a join and form a temporary table from it? If > that's possible, I could get all the data I need for a basic Union and I'd > be happy - I think:) > > cheers > > Kim -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]