[Solved] MySQL Query issue with select [closed]

by


Another approach to “join” two tables:

SELECT proposal.proposalID, client.name
FROM client, proposal
WHERE proposal.clientID = client.id;

Warning: I didn’t test this.

In order to understand what’s going on, I suggest you learn more about SQL Joins.
Some links to get you started:

http://www.w3schools.com/sql/sql_join.asp

http://en.wikipedia.org/wiki/Join_%28SQL%29

https://www.google.com/search?q=sql+join

2

solved MySQL Query issue with select [closed]