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!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
multiple table query with MIN()
JarlH, name_id is a column which associates that row's food to a particular date. For ex... food1, food2, food3 have a name_id of 1 so therefore those three foods are connected to the date with a pk of 1 (05062009). I guess it would be more readable if it was called date_id. ...WHERE name_id... -
multiple table query with MIN()
Thanks for the reply!! Sorry about not providing a sample table. You're right, it would make things a lot easier. Anyway... Table#1(dates) CREATE TABLE dates (pk INTEGER PRIMARY KEY, date INTEGER, weekly INTEGER) pk date weekly 1 05062009 1 2 05072009 1 3 05082009... -
multiple table query with MIN()
HI, New to the forums and I apologize if this isn't being posted in the right area... I am trying to run a pretty complex query (complex for me!!) and I have gotten the basic results i need but I am stuck on getting over the last hurdle. I presently have this query that does what i need it to...
