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