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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

wildcard symbols around a field in a join? 6
Query on two tables with matching null fields 4
Joining two tables 2
Create a distinct Join 3
How to combine two queries into one? 2
Hi........ very urgent join question 2
join keeps cascading 2
SQL Statement 2

Back
Top