Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dnagirl

    multiple left join problem

    This code was kindly provided me. It solves my problem: select s.seq_name, (select cat_name from categories join seq_cats using (cat_id) where cat_type_id = 3 and seq_cats.seq_id = s.seq_id) as tissue, (select cat_name from categories...
  2. dnagirl

    multiple left join problem

    Hi, I have 3 tables: sequence, seq_cats and categories. sequence has 2 fields of interest: seq_id (int(10) not null auto_increment primary key) seq_name (varchar(40) not null) categories has 3 fields of interest: cat_id (int(10) not null auto_increment primary key) cat_name (varchar(20) not...

Part and Inventory Search

Back
Top