Mr_Shaw
asked on
Data from table1 where no match on Table2
I would like to write a query which bring back all the data from table1 where there is match in table2.
The match uses a primary key called TableJoinKey
can anybody help.
Thanks
The match uses a primary key called TableJoinKey
can anybody help.
Thanks
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok i'll have a play arround...
Please could someone tell me what would happen if I used a left or right join.
Please could someone tell me what would happen if I used a left or right join.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
ASKER