search for: bands_labels

Displaying 1 result from an estimated 1 matches for "bands_labels".

2006 Apr 25
6
Searching over multiple MySQL tables
I am racking my brain over this, probably because I only know very simple mysql functions. Basically I''ve got a few tables, ex: Albums (id,name,band_id); Bands (id,name,label_id), and Label (id,name) I want to search through both album.name, band.name, and label.name throwing all results into a variable, with no redundant info. I think what I need to be doing is setting up some