I'm trying to do a series of JOINS

JOINING 'bandetails' table + 'venuedetails' table to 'gigdetails' VIA
'gig_bands' table and a series of ALIASES and the the 'labeldetails to 
each
band so I have some thing like

DATE VENUE HEADLINE SUPPORT1 SUPPORT2 HEADLINE_BIOG 
SUPPORT1_BIOG
SUPPORT2_BIOG HEADLINE_LABEL






#
# Table structure for table `gigdetails`
#

CREATE TABLE gigdetails (
  gig_id tinyint(3) unsigned NOT NULL auto_increment,
  date date NOT NULL default '0000-00-00',
  time time NOT NULL default '00:00:00',
  ticket_price decimal(4,2) NOT NULL default '5.00',
  PRIMARY KEY  (gig_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `gig_bands`
#

CREATE TABLE gig_bands (
  gig_id tinyint(3) unsigned NOT NULL default '0',
  band_id tinyint(3) unsigned NOT NULL default '0',
  slot_no tinyint(3) unsigned NOT NULL default '0'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `bandetails`
#

CREATE TABLE bandetails (
  band_id smallint(3) unsigned NOT NULL auto_increment,
  band_name varchar(64) NOT NULL default '',
  band_biog text,
  band_image varchar(128) default NULL,
  band_url varchar(128) default NULL,
  record_label_id int(11) default NULL,
  PRIMARY KEY  (band_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `gig_venue`
#

CREATE TABLE gig_venue (
  gig_id tinyint(3) unsigned NOT NULL default '0',
  venue_id tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (gig_id),
  KEY gig_id (gig_id),
  KEY venue_id (venue_id)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `labeldetails`
#

CREATE TABLE labeldetails (
  label_id smallint(5) unsigned NOT NULL auto_increment,
  label_name varchar(64) NOT NULL default '',
  label_biog text NOT NULL,
  label_url varchar(255) NOT NULL default '',
  PRIMARY KEY  (label_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `venuedetails`
#

CREATE TABLE venuedetails (
  venue_id tinyint(3) unsigned NOT NULL auto_increment,
  venue_name varchar(128) NOT NULL default '',
  venue_address varchar(128) NOT NULL default '',
  venue_url varchar(128) default NULL,
  PRIMARY KEY  (venue_id),
  KEY venue_id (venue_id)
) TYPE=MyISAM;


Tony