From: "Boyan Nedkov" <[EMAIL PROTECTED]>
> Putting more than one table in the FROM clause means tables are joined,
> then at least following problems could arise:
> - using WHERE clause you can have empty recordset returned and then
> COUNT conflicts with it because there is actually no any data to be
There won't be a conflict, COUNT(*) will just return zero. When you use
COUNT(*) there will _always_ be a row returned, either zero or the count.
> - joining two (or more) tables without using aliases to the equally
> named columns in the SELECT/WHERE/COUNT clauses will produce error
> message instead of expecting data;
You don't need an alias and the columns don't have to be equally named, but
yes, you have to "join" them somehow against some column. The original query
> - COUNT(*) wont work if u have equal table names in the tables;
I have no idea what you mean by that.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php