RE: Joining two talbes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> Can someone help me understand joining tables, and how I can do this:
> SELECT clients.business_name, details.quoted_price,
details.finish_date
> FROM clients, details WHERE clients.client_id = details.client_id =" .
> $HTTP_GET_VARS['id'];

Since when can you do

WHERE var1 = var2 = var3 ??

You need to do it such as:

WHERE var1 = var2 AND var1 = var3

---John W. Holmes...

PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux