Relationships in Queries?

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
 
S

scott

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
 

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
Summing 1 or 2 or 3 values from 3 tables 5
Union Query with division 2
Duplicate rows - Distinct Count 2
Making an Append Query from an unmatched Query 1

Top