There is a table "Persons":
| P_Id | LastName | FirstName | Address | City |
|---|---|---|---|---|
| 1 | Hansen | Ola | Timoteivn 10 | Sandnes |
| 2 | Svendson | Tove | Borgvn 23 | Sandnes |
| 3 | Pettersen | Kari | Storgt 20 | Stavanger |
| O_Id | OrderNo | P_Id |
|---|---|---|
| 1 | 77895 | 3 |
| 2 | 44678 | 3 |
| 3 | 22456 | 1 |
| 4 | 24562 | 1 |
| 5 | 34764 | 15 |
- JOIN
- FULL JOIN
Comments
And what kind of expression is a master Yoda, "It means - that no two rows can have the same" P_Id "."
It may ludche "It means - that the" P_Id "always unique.
And the error is the primary key in table "Persons".
Overall a very useful resource! Quote
Example: get the value for a person OrderNo Hansen.
SELECT LastName, FirstName, OrderNo
FROM Persons
INNER JOIN Orders ON Persons.P_id = Orders.P_id
WHERE LastName = 'Hansen'
If not mistaken, it should work. If you made a mistake, correct. I'm still learning, still (zapayany) admin that used in the head prokompilirovat b without any errors.
A section on the right side for whom??? This article is for your reference, nubl () Quote
I know without you!
where whore example, freaks? Quote
you do not nikto nichego Dolj Quote
you - Passive ***** ... yes, that's with two large letters "Paix" Quote