Jump to content

Archived

This topic is now archived and is closed to further replies.

Brendan

mysql query

Recommended Posts

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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.