Re: Query question.

2001-09-07 Thread Michael Garvin
gt; >select message >from project left join daily on project.uid = daily.uid >order by timestamp > >Check manual for syntax. > >Or am I missing something? > >- Ken >[EMAIL PROTECTED] > >At 05:47 PM 9/6/01 -0700, Michael Garvin wrote: > >>Ok, we just can&

Query question.

2001-09-06 Thread Michael Garvin
Ok, we just can't seem to find a solution for this problem. Thought I'd post it up to see if anyone has any input. Say you have 2 tables project_notes and daily_notes. Each table has a timestamp, and a user_id. Is there any way, in one query, to select all messages from both tables that were e

Re: Mysqld Dead But Subsys Locked

2001-09-05 Thread Michael Garvin
The confusion probably lies in the message saying the file should exist. There were 2 conditions to that statement, and the first (make sure that mysqld is running) hadn't been met. The file is SUPPOSED to be evidence that mysqld is running, and a socket connection is possible. However, in yo

Re: Query Help

2001-09-05 Thread Michael Garvin
The secret is to use the tags table twice, but you've got to rename them to avoid vagueness. select t1.tagnumbers,mem.days,mem.expdate from tags as t1,tags as t2,membersip as mem where t1.orderid = t2.tagid and t1.orderid = mem.tagid I believe that should work. [EMAIL PROTECTED] wrote: >Hello