Re: Selecting data from multiple tables

2009-11-18 Thread Shawn Green
Ashley M. Kirchner wrote: Hi folks, I'm trying to, possibly do the impossible here. I have to select data from 4 different tables to come up with the right information and I'm having one heck of time trying to figure it out. This is going to be a long email ... Table_1: +---+-

RE: Selecting data from multiple tables

2009-11-15 Thread Gavin Towey
These table names are extraordinarily confusing; especially since your schema is de-normalized. One of these tables should have (user_id int unsigned not null auto increment primary key, username varchar(100) ); All the rest should be using user_id. Anyway, to answer your first question: sel