select syntax

**slighltywhacked** · Jun 17, 2001 10:26

Is there a command in mysql to select the maximum value in a particular collum

**seanf** · Jun 17, 2001 10:31

Hi,

I think you have to do it like this :

PHP Code:


SELECT articles.*, lookup.*, writers.* FROM articles, lookup, writers WHERE writers.wid=lookup.wid & articles.aid=lookup.aid;

Sean

**Kevin Yank** · Jun 17, 2001 11:37

SELECT MAX(col_name) FROM tbl_name

**seanf** · Jun 17, 2001 12:21

Ok,

Did you edit your question or did that post in the wrong topic for some reason ?

**Kevin Yank** · Jun 17, 2001 12:24

Hmmm weird indeed, Sean. It says the post was changed, so I guess that explains it.

**seanf** · Jun 17, 2001 12:27

I missed that! The first question was about selecting everything when using table joins.

Sean

**Kevin Yank** · Jun 17, 2001 12:47

In fact, SELECT * FROM table1, table2, ... should still work.

User Tag List