Hi guys, I was wondering if you can help me or push me in the right direction with this query.
I have two databases; a db of "recording_global" data and a db of "dj_global" data. What I want to do is sort the "recording_global" data by "dj_global_name" which I will source from the "dj_global" db with the "recording_global_dj_id" that is in the "recording_global" db. I have included the schema of the two tables here: ----------8<---------- # # Table structure for table `dj_global` # CREATE TABLE dj_global ( dj_global_id mediumint(8) NOT NULL auto_increment, dj_global_name varchar(50) NOT NULL default '', dj_global_website varchar(255) NOT NULL default '', dj_global_dob date NOT NULL default '0000-00-00', dj_global_country_id mediumint(8) NOT NULL default '0', dj_global_city_id mediumint(8) NOT NULL default '0', PRIMARY KEY (dj_global_id) ) TYPE=MyISAM; # # Table structure for table `recording_global` # CREATE TABLE recording_global ( recording_global_id mediumint(8) NOT NULL auto_increment, recording_global_dj_id mediumint(8) NOT NULL default '0', recording_global_event_id mediumint(8) NOT NULL default '0', recording_global_venue_id mediumint(8) NOT NULL default '0', recording_global_city_id mediumint(8) NOT NULL default '0', recording_global_link varchar(255) NOT NULL default '0', recording_global_date date NOT NULL default '0000-00-00', recording_global_expirydate date NOT NULL default '0000-00-00', recording_global_counter mediumint(8) NOT NULL default '0', PRIMARY KEY (recording_global_id) ) TYPE=MyISAM; Any help much appreciated. > Ian Roke > Demand Planning > American Standard Companies - Hull, UK > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php