Welcome Guest, Not a member yet? Register   Sign In
Subquery or Join
#7

select table1.name,table2.score from table2 join table1 on table1.username = table2.username

it will only return table1.name,table2.score nothing else unless you add it to the field list
On the package it said needs Windows 7 or better. So I installed Linux.
Reply


Messages In This Thread
Subquery or Join - by omid_student - 09-27-2017, 06:27 AM
RE: Subquery or Join - by rtenny - 09-27-2017, 08:42 AM
RE: Subquery or Join - by omid_student - 09-27-2017, 08:48 AM
RE: Subquery or Join - by dave friend - 09-27-2017, 01:48 PM
RE: Subquery or Join - by omid_student - 09-28-2017, 11:31 AM
RE: Subquery or Join - by dave friend - 09-28-2017, 12:11 PM
RE: Subquery or Join - by rtenny - 09-29-2017, 07:08 AM
RE: Subquery or Join - by ciadvantage - 09-29-2017, 08:05 AM
RE: Subquery or Join - by omid_student - 09-29-2017, 12:52 PM
RE: Subquery or Join - by php_rocs - 09-29-2017, 04:00 PM
RE: Subquery or Join - by omid_student - 09-30-2017, 11:19 AM



Theme © iAndrew 2016 - Forum software by © MyBB