Relationships in Queries?

  • Thread starter Thread starter May
  • Start date Start date
M

May

actually, you are joining two tables only, but tell the
computer you want two criteria
(Table1.name1 = table2.name1) AND (Table1.name =
table2.name)

in order to do the left or right join, you have to make it
two left or two right at the same time

May
MCP in Access and SQL Server
 
Thank you for the info...Where do I hook these tables up with what
you gave me below? Sorry for all the questions..Still learning

Thanks
Scott
 
Back
Top