ASPN ActiveState Programmer Network
ActiveState
/ Home / Perl / PHP / Python / Tcl / XSLT /
/ Safari / My ASPN /
Cookbooks | Documentation | Mailing Lists | Modules | News Feeds | Products | User Groups


Recent Messages
List Archives
About the List
List Leaders
Subscription Options

View Subscriptions
Help

View by Topic
ActiveState
.NET Framework
Open Source
Perl
PHP
Python
Tcl
Web Services
XML & XSLT

View by Category
Database
General
SOAP
System Administration
Tools
User Interfaces
Web Programming
XML Programming


MyASPN >> Mail Archive >> php-db
php-db
[PHP-DB] Selecting data from multiple tables
by Awlad Hussain other posts by this author
Sep 27 2003 1:57PM messages near this date
[PHP-DB] Showing Average Visitors Per day | RE: [PHP-DB] Selecting data from multiple tables
I have three tables as shown below:

tbl1
---------------
user_id
username
password
..............
..............

tbl2
--------------
user_id
age (date)


tbl3
-----------
user_id
town
country

How can i construct sql query for example to select data from all three
tables where age is 30 and country is United Kingdom?

Many Thanks in Advance.

AH

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thread:
Awlad Hussain
Jack van Zanen

Privacy Policy | Email Opt-out | Feedback | Syndication
© ActiveState Software Inc. All rights reserved