Valleriani
asked on
MYSQL: Grabbing data from two tables
A query to grab specific data from two tables.
If I have one table with user ID and the user name,
Then I have a second table with a reference to the user ID, and some other information, lets say company name and company URL. How could I run a mysql query to get all the information needed.
What I'd want is the user name, the company name, and the url for example. So Username,CompanyName,Url grabbed from MYSQL within one query from both tables.
How is this possible? Thank you!
If I have one table with user ID and the user name,
Then I have a second table with a reference to the user ID, and some other information, lets say company name and company URL. How could I run a mysql query to get all the information needed.
What I'd want is the user name, the company name, and the url for example. So Username,CompanyName,Url grabbed from MYSQL within one query from both tables.
How is this possible? Thank you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER