mysql query

[Brendan]

Alright say i have the following table structure:

Table 1
_____________________________

|----USERNAME----|----ADDDATE----|

-----myname-----------2006-01-02----
----myname2----------2006-01-03----
______________________________


Table 2
_____________________________________

|---USERNAME---|----FIELD1----|----FIELD2----|

-----myname-----------blue-----------tall----
----myname2----------black----------short---
______________________________________
Now i want to have a mysql query that takes table 2, searches through it and picks out certain rows depending on the where clause that is set, and then match those rows usernames to the usernames on table 1 so that the username, adddate, field1, and field 2 are all returned in the same query.

Thanks,
-Brendan

[realjumper]

Check this out...http://www.tizag.com/mysqlTutorial/mysqljoins.php

[Brendan]

thanks alot man, that helped alot.